/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

1 vote385 views2 answers
Laravel check if email is real
PHP Laravel
0 vote282 views1 answer
Redirect with compact laravel
PHP Laravel
0 vote332 views10 answers
Laravel sanctum
PHP Laravel
2 votes229 views1 answer
Php variable in alert box
PHP
0 vote270 views2 answers
Php variable undefined inside function argument
PHP
0 vote338 views1 answer
Laravel vue error 500
PHP Laravel
1 vote285 views1 answer
Typo3 fluid inline if
PHP
9 votes302 views3 answers
Laravel image validation
PHP Laravel
0 vote357 views1 answer
Wordpress function _() not working
PHP Wordpress
7 votes263 views2 answers
Wordpress the loop
PHP

Share