/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 vote336 views1 answer
How to save data from api to laravel
PHP Laravel
33 votes334 views6 answers
Laravel query builder
PHP Laravel
22 votes336 views6 answers
Laravel where like
PHP Laravel
0 vote380 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
12 votes503 views6 answers
Email validation in laravel
PHP Laravel
0 vote328 views2 answers
Laravel sortby varchar date
PHP Laravel
0 vote348 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
0 vote305 views1 answer
Loop laravel 8
PHP Laravel
1 vote367 views1 answer
Laravel 8 bootstrap pagination fix
PHP Laravel
1 vote365 views4 answers
Laravel queue timeout
PHP Laravel

Share