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 votes274 views3 answers
Install php7.4 in linux server
PHP
1 vote266 views1 answer
Why storage link do not work in host for laravel
PHP
0 vote282 views1 answer
Menu order for posts
PHP
3 votes255 views4 answers
Get base url in wordpress
PHP
18 votes390 views5 answers
Wp debug
PHP Wordpress
11 votes288 views4 answers
How to check php version in php
PHP
4 votes260 views2 answers
Define php
PHP
4 votes345 views2 answers
Validate year laravel
PHP Laravel
0 vote254 views1 answer
Mysqli php 7.4
PHP
0 vote290 views5 answers
Run schedule laravel
PHP Laravel