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 votes260 views4 answers
Unique check with multiple columns laravel validation
PHP
2 votes262 views3 answers
Laravel public static variable
PHP
0 vote311 views1 answer
Wp automatic-feed-links
PHP Wordpress
0 vote269 views1 answer
How to add in massive php
PHP
4 votes225 views1 answer
Connection failed: could not find driver php
PHP
1 vote259 views3 answers
Eloquent where raw
PHP
19 votes302 views5 answers
Php get random element from array
PHP
12 votes310 views2 answers
Get current authenticated user laravel
PHP Laravel
0 vote258 views1 answer
Php jwt firebase
PHP
0 vote298 views2 answers
Stop php execution with javascript
PHP