/PHP/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

0 vote231 views1 answer
How to pass token with post request laravel
PHP Laravel
23 votes205 views6 answers
Laravel model insert
PHP Laravel
0 vote188 views1 answer
Fakher ul islam khan
PHP
0 vote240 views3 answers
Run queue after x minutes laravel
PHP Laravel
0 vote205 views1 answer
Php on page query
PHP
0 vote222 views1 answer
Turn off wordpress user list exposed
PHP Wordpress
0 vote196 views3 answers
Laravel validation alphanumeric with spaces
PHP
0 vote201 views1 answer
Artisan command on live server
PHP
12 votes228 views3 answers
Call controller function from another controller laravel
PHP Laravel
5 votes192 views4 answers
Php echo arry
PHP

Share