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

6 votes135 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel
6 votes150 views3 answers
How assign default value to laravel migration column
PHP Laravel
0 vote142 views2 answers
Php json request get value
PHP
4 votes120 views3 answers
Wp+get feature image
PHP
0 vote126 views1 answer
Defining constant in config laravel
PHP
0 vote142 views2 answers
Spatie permission
PHP
0 vote116 views1 answer
Get server ip php
PHP
1 vote95 views1 answer
Laravel validation on fields inside array in request
PHP Laravel
8 votes145 views6 answers
Laravel new project
PHP Laravel
0 vote112 views1 answer
Pagination javascript php
PHP