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

8 votes403 views6 answers
Laravel collection unique
PHP Laravel
4 votes344 views2 answers
Update-alternatives java
PHP
0 vote331 views6 answers
Convert php to python online
PHP
1 vote326 views2 answers
How to display data from mysql database into html table using php
PHP
0 vote393 views1 answer
Db seed in controller
PHP
0 vote316 views2 answers
Laravel rename file ftp
PHP
1 vote443 views3 answers
Codeigniter store session data
PHP CodeIgniter
13 votes363 views5 answers
Zsh: command not found: laravel
PHP Laravel
0 vote354 views1 answer
Php url variable xss sanitize
PHP
18 votes330 views1 answer
Specified key was too long; max key length is 767 bytes (s
PHP