/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

1 vote257 views2 answers
{{count laravel
PHP Laravel
0 vote317 views1 answer
Laravel nova resolveUsing
PHP Laravel
0 vote347 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote313 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
7 votes366 views3 answers
Laravel how to call function in same controller
PHP Laravel
0 vote296 views1 answer
Case inside laravel query
PHP Laravel
0 vote322 views1 answer
Request file create cammand laravel
PHP Laravel
2 votes312 views2 answers
Laravel eloquent get all where in
PHP Laravel
1 vote321 views1 answer
Laravel sentence word count
PHP Laravel
0 vote311 views1 answer
Laravel Password & Password_Confirmation Validation
PHP Laravel

Share