Concat & group_concat

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?

GROUP_CONCAT(CONCAT(display_town, ', ', display_county) SEPARATOR '<br>'))

You’re a star thank you