You can chanage separator as follows: mysql> SELECT *, -> GROUP_CONCAT(DISTINCT test_score -> ORDER BY test_score DESC SEPARATOR ‘ |’) -> FROM table_name

… the GROUP BY operation: function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Where… | 6 | | 3 | 7 | +—-+———–+ SELECT id,GROUP_CONCAT(client_id) FROM services WHERE id = 3 GROUP BY id; +—-+————————-+ | id | GROUP_CONCAT(client_id) | +—-+————————-+ | 3 | 5,6…

… truncated to the maximum length that is given by the group_concat_max_len system variable, which has a default value of… value of group_concat_max_len at runtime is as follows, where val is an unsigned integer: SET [GLOBAL | SESSION] group_concat_max_len = val; Current values in Our server max_allowed_packet = 67107840 group_concat_max_len = 1024 Query…

… ! I’ve a little problem using group_concat and user variable. I tried to set a group_concat(id) result into a @var, and…> SELECT @lid := CAST(GROUP_CONCAT(id) AS CHAR) FROM `user` WHERE `nom` in(‘renaud’, ‘julie’, ‘lucy’); +—————————————-+ | @lid := CAST(GROUP_CONCAT(id) AS CHAR) | +—————————————-+ | 4…

[...] GROUP_CONCAT useful GROUP BY extension: MySQL has useful extension to the GROUP BY operation: function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. [...]

… a bridge table called member_categories. SELECT DISTINCT(md.id),GROUP_CONCAT(categories.category SEPARATOR ‘, ‘) AS category FROM member_directory md LEFT… | CONDOMINIUMS | ==================================================================== If I add any conditions regarding the category, the GROUP_CONCAT starts returning only the category mentioned in the WHERE clause…