PHP

concat() function using laravel eloquent query

concat() function using laravel update query
concat and search in laravel eloquent
$query->where(DB::raw("CONCAT(`first_name`,' ',`last_name`)"), 'like', '%' . request('filter') . '%');

concat function using laravel update query

concat() function using laravel update query

$driver_update = Driver::where('id',$id)->update(['service_ids' => DB::raw('concat(service_ids,",","'.$service_id.'")')]);

concat in where clause laravel query builder

$query->orWhere(DB::raw("CONCAT(`nvp`, ' ', `vpv`)"), 'LIKE', "%".$this->searchNeedle."%");

sql - Laravel concat in query (where condition)

$query->orWhereRaw("CONCAT(`nvp`, ' ', `vpv`) LIKE ?", ['%'.$this->searchNeedle.'%']);