How to concatenate string values that have a similar column?

Question

Mountains' Table:

I want to write a query that concatenates the countries that are in the same mountain. So, in the result table, I'll have one a time the name of the mountain and a column which is named countries with the concatenated countries separated with commas.

Give you give an example of how the final output should look? What do you want to do with province? — Phaelax z, Sep 09 '21 at 13:56
Assuming you are using MYSQL a quick search on google brought back [this thread](https://stackoverflow.com/questions/3492539/mysql-multiple-row-as-comma-separated-single-row). I think you want to use group_concat — Bee_Riii, Sep 09 '21 at 13:56
Does this answer your question? [MySQL Results as comma separated list](https://stackoverflow.com/questions/662207/mysql-results-as-comma-separated-list) — JNevill, Sep 09 '21 at 13:57
Please provide enough code so others can better understand or reproduce the problem. — Community, Sep 15 '21 at 12:10

score 0 · Answer 1 · answered Sep 09 '21 at 14:00

0

SELECT  GROUP_CONCAT (Country) as "country" 
FROM table_name group by Mountain;

Use GROUP_CONCAT you can learn more about it here:- GROUP_CONCAT

answered Sep 09 '21 at 14:00

rahul yadav

46
5

How to concatenate string values that have a similar column?

1 Answers1