/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

46 votes174 views6 answers
Add column to migration laravel
PHP Laravel
0 vote133 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
47 votes160 views6 answers
How to add new column in laravel migration
PHP Laravel
13 votes144 views6 answers
Prefix laravel route
PHP Laravel
0 vote129 views2 answers
Access paginator object attribute in laravel
PHP Laravel
9 votes131 views4 answers
Laravel merge collections
PHP Laravel
0 vote129 views1 answer
Laravel blank page
PHP Laravel
0 vote116 views1 answer
Dynamic modal name appending in laravel
PHP Laravel
27 votes189 views3 answers
Laravel what is migrations
PHP Laravel
10 votes142 views2 answers
Laravel array to string conversion
PHP Laravel

Share