my sql group concat code example

Example 1: mysql group_concat distinct

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

Example 2: group_concat mysql

GROUP_CONCAT(expr);