Paweł Hajdan Paweł Hajdan - 1 year ago 79
SQL Question

How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this:


id string
1 A
1 B
2 C


to this:


id string
1 A B
2 C

Answer Source
SELECT id, GROUP_CONCAT(string SEPARATOR ' ') FROM table GROUP BY id;

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

From the link above, GROUP_CONCAT: This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download