Eloquent whereRaw

$orders = DB::table('orders')
                ->whereRaw('price > IF(state = "TX", ?, 100)', [200])
                ->get();

#To use in search
$paciente   = $query->whereRaw("(
        LOWER(name)             like '%". strtolower($search) ."%' OR
        LOWER(sku)              like '%". strtolower($search) ."%' OR
        LOWER(codigo)           like '%". strtolower($search) ."%' OR
        LOWER(descricao_curta)  like '%". strtolower($search) ."%'
    )");

Source: laravel.com

Similar codes

0 vote352 views1 answer
How to execute “php artisan migrate” and other Laravel commands in remote server?
PHP Laravel
0 vote363 views1 answer
Php faker long text
PHP
0 vote341 views1 answer
Laravel add model to one to many relationship
PHP Laravel
0 vote313 views1 answer
Smarty shorthand if
PHP
-1 vote334 views1 answer
Toast in laravel
PHP Laravel
3 votes268 views3 answers
Ternary operator in php
PHP
1 vote309 views1 answer
How to retrieve value from stdclass array in php
PHP
31 votes319 views2 answers
Laravel sample controller
PHP Laravel
-1 vote303 views1 answer
Update php ubuntu
PHP
2 votes318 views3 answers
Format date laravel timestamp view
PHP