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 vote240 views1 answer
Laravel fetch max value
PHP Laravel
0 vote185 views1 answer
Compact example in php
PHP
3 votes241 views2 answers
How get the size of image in laravel
PHP Laravel
0 vote209 views1 answer
How to get only decimal value in php
PHP
5 votes221 views2 answers
Laravel migration price
PHP Laravel
0 vote198 views1 answer
How to check if a user is logged in in a non middleware controller in laravel
PHP
1 vote194 views1 answer
Cake tmp name
PHP
0 vote212 views1 answer
Last page url in php laravel
PHP
12 votes200 views4 answers
Php array remove empty values recursive
PHP
0 vote203 views1 answer
The key "initial" is not recognized and ignored.
PHP