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

1 vote213 views1 answer
Php check if query returns results
PHP
10 votes217 views4 answers
Laravel table data types
PHP Laravel
0 vote219 views1 answer
Function to find total number of students in wplms
PHP
1 vote209 views1 answer
Php install xdebug mac
PHP
0 vote239 views1 answer
Composer won't use php version for subdomain multiphp
PHP
4 votes318 views2 answers
Php select option selected from database
PHP
15 votes288 views3 answers
Foreign id laravel migration
PHP Laravel
1 vote276 views1 answer
Changer le logo Admin WordPress
PHP
2 votes218 views2 answers
Laravel list of models
PHP
53 votes212 views2 answers
Transforming string to integer in php
PHP