Hi Guys
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:
Canterbury, Kent
,Kent, Kent
However the output i’m looking for is:
Canterbury, Kent
Kent, Kent
How can I get rid of that extra comma?