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

1 vote123 views1 answer
Laravel string builder
PHP Laravel
0 vote142 views1 answer
How to validate students who made payment in php and mysql
PHP
0 vote131 views1 answer
Agregar clases de rol al body en WordPress
PHP Wordpress
0 vote104 views1 answer
How see the list all artisan in laravel
PHP
0 vote193 views1 answer
Ajouter du contenu personnalisé sous chaque article/publication WordPress
PHP Wordpress
1 vote159 views1 answer
Break and continue in laravel
PHP Laravel
12 votes112 views3 answers
Php order array by specific key
PHP
6 votes119 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
4 votes108 views1 answer
Php get php.ini location from termina
PHP
0 vote124 views2 answers
Laravel pagination vuetify
PHP