LMSouq
general-dev Open

GROUP_CONCAT comma separator

US
user984580
1 month ago
3 views
Problem Description
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?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base