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

3 votes207 views1 answer
You may need an appropriate loader to handle this file type, currently no loaders are configured to process this file laravel
PHP Laravel
20 votes172 views4 answers
Php simple server
PHP
4 votes178 views5 answers
Laravel db inserr
PHP
12 votes197 views6 answers
Set session data in laravel
PHP Laravel
0 vote190 views3 answers
Laravel postgres deadlock
PHP Laravel
1 vote242 views1 answer
How if charactor is exist in text in laravel
PHP Laravel
2 votes182 views1 answer
Php array unique array to string conversion
PHP
0 vote178 views1 answer
Tax query by term id
PHP
15 votes239 views4 answers
Php Error Reporting
PHP
0 vote173 views1 answer
Nginx phpmyadmin subdirectory
PHP