xxxxxxxxxx
$query->orWhere(DB::raw("CONCAT(`nvp`, ' ', `vpv`)"), 'LIKE', "%".$this->searchNeedle."%");
xxxxxxxxxx
$query = DB::table('mbo_party')->where(DB::raw("CONCAT(first,' ',last)"), 'LIKE', '%' . $party_name . '%')->first();
xxxxxxxxxx
concat() function using laravel update query
$driver_update = Driver::where('id',$id)->update(['service_ids' => DB::raw('concat(service_ids,",","'.$service_id.'")')]);
xxxxxxxxxx
$query->orWhereRaw("CONCAT(`nvp`, ' ', `vpv`) LIKE ?", ['%'.$this->searchNeedle.'%']);