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 vote206 views1 answer
Détecter les utilisateurs mobiles
PHP
7 votes161 views3 answers
Laravel data type
PHP
0 vote149 views9 answers
How to form data to another file in php
PHP
0 vote120 views1 answer
Size array php
PHP
1 vote232 views1 answer
How to add property to the request object in laravel
PHP Laravel
5 votes159 views1 answer
Get templete uri
PHP
15 votes246 views2 answers
Php get type of object
PHP
0 vote146 views1 answer
Why css not working with php file
PHP
0 vote186 views1 answer
Seprate day and year from laravel to timestamp
PHP Laravel
2 votes157 views3 answers
In PackageManifest.php line 122: Undefined index: name
PHP