/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

44 votes232 views6 answers
Laravel migrate seed
PHP Laravel
16 votes193 views6 answers
Laravel validation array
PHP Laravel
8 votes215 views3 answers
Force delete soft delete laravel
PHP Laravel
0 vote207 views1 answer
Laravel include files
PHP Laravel
12 votes239 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
16 votes205 views6 answers
Laravel redirect back
PHP Laravel
0 vote232 views1 answer
Laravel check if postback
PHP Laravel
0 vote224 views1 answer
Logout all users laravel 8
PHP Laravel
0 vote234 views1 answer
Laravel.log" could not be opened in append mode
PHP Laravel
63 votes309 views6 answers
Clear all cache in laravel
PHP Laravel

Share