GROUP_CONCAT(DISTINCT CONCAT( 'MAX(IF code example

Example: mysql group_concat distinct

SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ' ') FROM table