please I want to use group_concat in a query using eloquent and not raw queries.
here is the code which i tried to execute and did't work for me:
commands::join('products', 'products.id', '=','commands.idproduct')
->select('commands.username','**group_concat(products.name)**')
->group by ('commands. username')
->get();
Thanks in advance :)
I just used:
use DB;
and in my query I used
DB::raw('group_concat(products.name)')