Question

I have a table containing countries:

id     country
------------
0     Monaco 
1     Mongolia
2     Montenegro
3     Morocco
4     Mozambique
5     Myanmar

I have a sub query that looks like this.

(SELECT country FROM COUNTRIES WHERE id < 10) AS ´Trip´

I want to have that subquery to be formatted as a string like this:

Monaco, Mongolia, Montenegro, Morocco, Mozambique, Myanmar

Is that possible?

Answer 1

You can use the group_concat function:

SELECT group_concat(country,  ,  ) FROM countries WHERE id < 10

Answer 2

What Lukas said, but use the SEPARATOR for your , s

SELECT group_concat(country SEPARATOR  ,  ) FROM countries WHERE id < 10

This is useful if you want a ; instead of a ,