How to use GROUP BY to concatenate strings in MySQL?

Question

Basically the question is how to get from this:

 foo_id   foo_name 1        A 1        B 2        C 

to this:

 foo_id   foo_name 1        A B 2        C 

Answer 1

SELECT id, GROUP_CONCAT(name SEPARATOR ' ') FROM table GROUP BY id; 

https://dev.mysql.com/doc/refman/8.0/en/aggregate-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.

Answer 2

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

More details here.

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.