GROUP_CONCAT(expr)

GROUP_CONCAT(expr)

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. The full syntax is as follows:

 GROUP_CONCAT([DISTINCT] expr [,expr ...]              [ORDER BY {unsigned_integer | col_name | expr}                  [ASC | DESC] [,col_name ...]]              [SEPARATOR str_val]) 

 mysql> SELECT student_name,     ->     GROUP_CONCAT(test_score)     ->     FROM student     ->     GROUP BY student_name; 

Or:

 mysql> SELECT student_name,     ->     GROUP_CONCAT(DISTINCT test_score     ->               ORDER BY test_score DESC SEPARATOR ' ')     ->     FROM student     ->     GROUP BY student_name;