GROUP_CONCAT in MYSQL

Syntax -

SELECT GROUP_CONCAT(DISTINCT(categories) SEPARATOR ' ') FROM table

DISTINCT for unique categories








SEPARATOR for seperate two categories by space, comma.

        for space - ' '

        for commna - ','

        for new line - '/n'