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

9 votes153 views4 answers
Get current page php
PHP
0 vote170 views1 answer
Cakephp find_in_set
PHP
0 vote177 views2 answers
How to save array of inputs in php
PHP
0 vote165 views1 answer
Current time input field in laravel form
PHP
1 vote178 views1 answer
Laravel word count utf8
PHP Laravel
0 vote151 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP
0 vote232 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
-1 vote167 views1 answer
Element check cakphp
PHP
1 vote187 views2 answers
Wp get meta field value
PHP Wordpress
0 vote153 views1 answer
Session not working php
PHP