How to merge multiple rows from MySQL DB into one?

Question

PHP

There is a table
, you need to merge the rows from the clothes_name column so that the result is: Polo, Versache, Adidas.
How to implement it? Tell me please.

Answer 1

SELECT GROUP_CONCAT(`clothes_name` SEPARATOR ', ') FROM `table` GROUP BY 1