CODE EXAMPLE FOR 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') . '%');