GROUP_CONCAT with different SEPARATOR in laravel Example
Whenever, you need to use GROUP_CONCAT with differente separator(I mean default separator is ',', But you want to change '@','#','&' etc as you want). then you have to use use SEPARATOR keyword in GROUP_CONCAT(). If you are working on laravel then you have to also use DB::raw() for write GROUP_CONCAT() inside the this function.
So, Basically how to change seprator in group_concat(), In following example i change ',' separator into '@'.you can use the following example how to use in laravel 4 and 5.
Example:
$items = DB::table('items')
->select("items.id","items.name"
,DB::raw("(GROUP_CONCAT(items_city.name SEPARATOR '@')) as `cities`"))
->leftjoin("items_city","items_city.item_id","=","items.id")
->groupBy('items.id')
->get();
Try this.....

My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.