/PHP/Laravel/How to concat in where clause like laravel query builder

How to concat in where clause like 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

0 vote236 views1 answer
Laravel eloquent save method return value
PHP Laravel
0 vote183 views1 answer
Laravel Auth::logoutOtherDevices
PHP Laravel
0 vote194 views1 answer
Laravel token logout
PHP Laravel
1 vote204 views2 answers
Laravel maximum execution time of 30 seconds exceeded
PHP Laravel
26 votes186 views4 answers
Where is cache file in laravel
PHP Laravel
23 votes190 views6 answers
Updateorcreate laravel
PHP Laravel
0 vote195 views1 answer
Laravel response json status 500
PHP Laravel
4 votes172 views2 answers
Delete all rows in table laravel
PHP Laravel
-1 vote193 views1 answer
Laravel orderby with relation
PHP Laravel
14 votes213 views6 answers
Laravel create model and migration
PHP Laravel

Share