Question : how to concat in where clause like laravel query builder
Answered by : cleophas-o
$query = DB::table('mbo_party')->where(DB::raw("CONCAT(first,' ',last)"), 'LIKE', '%' . $party_name . '%')->first();Source : https://stackoverflow.com/questions/52568648/how-to-use-concat-in-laravel-where-clause-without-using-model | Last Update : Thu, 15 Oct 20
Question : concat() function using laravel eloquent query
Answered by : manoj-kumar
concat() function using laravel update query
concat and search in laravel eloquent
$query->where(DB::raw("CONCAT(`first_name`,' ',`last_name`)"), 'like', '%' . request('filter') . '%');Source : | Last Update : Mon, 30 May 22
Question : concat function using laravel update query
Answered by : sivan
concat() function using laravel update query
$driver_update = Driver::where('id',$id)->update(['service_ids' => DB::raw('concat(service_ids,",","'.$service_id.'")')]);Source : http://localhost/phpmyadmin/index.php?route=/sql&db=productuser_servisclass&table=drivers&pos=0 | Last Update : Fri, 13 May 22
Question : concat in where clause laravel query builder
Answered by : cleophas-o
$query->orWhere(DB::raw("CONCAT(`nvp`, ' ', `vpv`)"), 'LIKE', "%".$this->searchNeedle."%");Source : https://stackoverflow.com/questions/25244317/laravel-concat-in-query-where-condition | Last Update : Thu, 15 Oct 20
Question : sql - Laravel concat in query (where condition)
Answered by : belaid-nacereddine
$query->orWhereRaw("CONCAT(`nvp`, ' ', `vpv`) LIKE ?", ['%'.$this->searchNeedle.'%']);Source : https://sqlerrors.com/howto/2758/sql---Laravel-concat-in-query-(where-condition) | Last Update : Thu, 18 Aug 22