/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

64 votes89 views6 answers
Delete cache laravel
PHP Laravel
16 votes52 views6 answers
Laravel group routes
PHP Laravel
12 votes57 views5 answers
Laravel run single migration
PHP Laravel
35 votes49 views6 answers
Laravel db query
PHP Laravel
1 vote52 views1 answer
Laravel group by created_at date only
PHP Laravel
1 vote51 views1 answer
Nested resources laravel
PHP Laravel
0 vote69 views1 answer
Laravel collective form include image
PHP Laravel
7 votes47 views2 answers
Laravel having between
PHP Laravel
0 vote48 views1 answer
Php laravel rount price to 99
PHP Laravel
0 vote47 views1 answer
Laravel post request page csrf disable
PHP Laravel

Share