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 vote207 views1 answer
Mailgun composer
PHP
0 vote248 views2 answers
Show all terms of a custom taxonomy
PHP
3 votes251 views2 answers
Replace multiple characters one string php
PHP
0 vote243 views2 answers
Option value selected in laravel blade
PHP
0 vote328 views1 answer
Codeigniter check view file exists
PHP CodeIgniter
2 votes266 views2 answers
How to add data to the request object in laravel
PHP
0 vote387 views1 answer
Yii2 arraydataprovider
PHP Yii
8 votes290 views3 answers
Magento 2.4.3 how to log
PHP
-2 votes281 views3 answers
Upgrade php 7.3 centos 7
PHP
8 votes273 views6 answers
Laravel collection sum
PHP