/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

23 votes180 views6 answers
Laravel 8 route
PHP Laravel
2 votes192 views2 answers
Laravel list of models
PHP Laravel
1 vote162 views3 answers
Laravel convert timestamp to date
PHP Laravel
1 vote150 views1 answer
Isset blade laravel
PHP Laravel
0 vote152 views1 answer
Passing parameters with route keyword in blade laravel
PHP Laravel
2 votes159 views1 answer
Laravel model wherein update
PHP Laravel
9 votes168 views4 answers
Laravel merge collections
PHP Laravel
-4 votes166 views1 answer
Alert laravel 7
PHP Laravel
2 votes169 views1 answer
Multiple routes same controller laravel
PHP Laravel
7 votes162 views1 answer
Laravel wher in
PHP Laravel

Share