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

0 vote290 views1 answer
String to lowercase accentuation hyphenated
PHP
1 vote294 views1 answer
Php get remote file last modified
PHP
1 vote333 views2 answers
Find index of a character in a string php
PHP
0 vote301 views1 answer
Laravel vreeze
PHP
1 vote356 views1 answer
Laravel date rule before 18 years ago
PHP Laravel
0 vote303 views1 answer
Php leggere file txt riga per riga
PHP
0 vote313 views2 answers
Php read xml file into array
PHP
39 votes353 views3 answers
Add new column to existing table laravel
PHP Laravel
0 vote289 views1 answer
Remove autoupdate wordpress
PHP
0 vote310 views1 answer
Php pdo bindvalue array
PHP