/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 vote167 views1 answer
Laravel blade all syntex description
PHP
0 vote97 views1 answer
How to get parameter value from request symfony
PHP
3 votes122 views3 answers
Ternary operator in php
PHP
0 vote168 views1 answer
Laravel asset prevent browser caching
PHP Laravel
4 votes151 views2 answers
Laravel 5 use env variable in blade
PHP
0 vote130 views1 answer
Magento 2 laravel valet 502 bad gateway
PHP Laravel
0 vote150 views1 answer
Enable trash for media wordpress
PHP
0 vote140 views1 answer
Multe data on database laravel
PHP Laravel
7 votes147 views2 answers
Laravel carbon get month number
PHP Laravel
0 vote127 views1 answer
Turn off wordpress user list exposed
PHP

Share