/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

6 votes225 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
0 vote233 views3 answers
Laravel 7 upload file s3
PHP Laravel
5 votes247 views2 answers
Laravel - Send mail using mail class
PHP Laravel
23 votes208 views6 answers
Laravel logs
PHP Laravel
12 votes253 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
1 vote235 views1 answer
Laravel child relation order by desc
PHP Laravel
10 votes201 views2 answers
Laravel 8 try catch
PHP Laravel
6 votes231 views2 answers
Laravel findorfail
PHP Laravel
-1 vote242 views1 answer
How to check if there is an authenticated user laravel
PHP Laravel
0 vote248 views1 answer
Laravel find or fail exception
PHP Laravel

Share