/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 vote334 views1 answer
Raw query in laravel with parameters
PHP
0 vote337 views3 answers
Laravel query builder get last insert id
PHP Laravel
0 vote375 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
8 votes346 views2 answers
How to debug php
PHP
0 vote364 views1 answer
Change WordPress Login Logo Url
PHP Wordpress
0 vote388 views1 answer
Cakephp extract array
PHP CakePHP
2 votes290 views1 answer
Interval Between Different Dates
PHP
0 vote317 views1 answer
If order has product id in array
PHP
0 vote331 views1 answer
Get product price by id woocommerce snippet
PHP
35 votes303 views5 answers
Remove the Last Character From a String in PHP
PHP

Share