/PHP/Laravel/Concat in where clause laravel query builder

Concat in where clause laravel query builder

How to concat in where clause like laravel query builder

$query = DB::table('mbo_party')->where(DB::raw("CONCAT(first,' ',last)"), 'LIKE', '%' . $party_name . '%')->first();

0

Source: stackoverflow.com

Concat in where clause laravel query builder

$query->orWhere(DB::raw("CONCAT(`nvp`, ' ', `vpv`)"), 'LIKE', "%".$this->searchNeedle."%");

0

Source: stackoverflow.com

Similar codes

14 votes176 views5 answers
Laravel eloquent get last record
PHP Laravel
5 votes261 views2 answers
Laravel redirect with message to section
PHP Laravel
39 votes177 views6 answers
Laravel foreign key constraint
PHP Laravel
46 votes216 views6 answers
Laravel make controller with model
PHP Laravel
0 vote177 views1 answer
Blade check user role laravel
PHP Laravel
-1 vote187 views1 answer
When to create a service in laravel
PHP Laravel
2 votes155 views1 answer
Laravel force login by id
PHP Laravel
1 vote168 views2 answers
Time left laravel seconds
PHP Laravel
6 votes301 views2 answers
Laravel migration table column nullable
PHP Laravel
0 vote168 views1 answer
Laravel collection times
PHP Laravel

Share