I'm trying to group multiple rows into one column on my database. I'm using the following sub query:
concat(group_concat(display_town, ', ', display_county, '<br>')) as display_name
The output i'm getting is:
However the output i'm looking for is:
How can I get rid of that extra comma?
GROUP_CONCAT(CONCAT(display_town, ', ', display_county) SEPARATOR '<br>'))