GROUP CONCAT comma separator - MySQL

Question

I have a query where I am using GROUP CONCAT and a custom separator as my results may contain commas   ----   This all works well  however it is still comma separated  so my output is   Result A---- Result B---- Result C----   How can I make it so the output is   Result A----Result B----Result C----   I thought this was the idea of a custom separator   Failing that  can you escape commas in your results  so I can explode in PHP by the GROUP CONCAT commas

User · Answer

Looks like you re missing the SEPARATOR keyword in the GROUP CONCAT function   GROUP CONCAT artists artistname SEPARATOR  ----     The way you ve written it  you re concatenating artists artistname with the  ----  string using the default comma separator

User · Answer

Query to achieve your requirment  SELECT id GROUP CONCAT text SEPARATOR      AS text FROM table name group by id

User · Answer

Or  if you are doing a split - join     GROUP CONCAT split thing         ----   AS thing name    You may want to inclue WITHIN RECORD  like this   GROUP CONCAT split thing         ----   WITHIN RECORD AS thing name    from BigQuery API page

[mysql] GROUP_CONCAT comma separator - MySQL

Examples related to mysql

Examples related to group-concat

Examples related to separator