/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

1 vote351 views1 answer
Laravel realation with has
PHP Laravel
0 vote360 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
0 vote332 views1 answer
Markdown mail html rendering laravel
PHP Laravel
3 votes359 views3 answers
Logout in laravel 8
PHP Laravel
0 vote425 views1 answer
ErrorException Undefined index(laravel 7 array helpers)
PHP Laravel
0 vote378 views1 answer
Old value on edit table laravel 6
PHP Laravel
0 vote383 views1 answer
Laravel collection prepend
PHP Laravel
0 vote381 views1 answer
Use id as key in co;lection laravel
PHP Laravel
3 votes376 views2 answers
Laravel required if it meet some value from another field
PHP Laravel
0 vote369 views1 answer
Email configuration for gmail in laravel
PHP Laravel

Share