GROUP_CONCAT(expr)

This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values

SELECT GROUP_CONCAT( Name )
FROM category
LIMIT 0 , 30

 

return: 

GROUP_CONCAT(Name)

ABC, DCE, CCC