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 votes344 views3 answers
Remove .php from url
PHP
4 votes364 views4 answers
Multiple middleware laravel
PHP Laravel
20 votes319 views3 answers
Json url decode php
PHP
6 votes378 views2 answers
Findorfail laravel
PHP Laravel
0 vote317 views1 answer
Enum php 8.1
PHP
0 vote392 views2 answers
Where are WordPress Pages and Posts Stored
PHP Wordpress
3 votes341 views2 answers
Php utf8_decode
PHP
4 votes325 views1 answer
Get client size in laravel
PHP
0 vote295 views1 answer
What is scalar data type in php
PHP
0 vote312 views1 answer
Mysqli_real_connect(): (hy000/2002): no such file or directory
PHP