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 vote271 views1 answer
Php setcookie infinite
PHP
0 vote297 views1 answer
Echo first 100 prime numbers php
PHP
14 votes386 views6 answers
Laravel create model and migration
PHP Laravel
3 votes315 views3 answers
Php stdclass to array
PHP
7 votes376 views3 answers
Call table name in model laravel
PHP Laravel
13 votes329 views4 answers
Php get domain from url
PHP
0 vote346 views1 answer
Wordpress wpdb delete
PHP Wordpress
-1 vote342 views1 answer
Php button to another page
PHP
0 vote356 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP
1 vote328 views2 answers
Symnfony bearer token
PHP