MySQL: Sort GROUP_CONCAT values

Answer 1

Sure, see http://dev.mysql.com/doc/refman/...tions.html#function_group-concat:

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

Answer 2

do you mean to order by ?

SELECT _key, COUNT(*) as cnt, GROUP_CONCAT(_value ORDER BY _value SEPARATOR ', ') as value_list FROM group_concat_test GROUP BY _key ORDER BY _key;