sql group_concat group by

今日先知原來有group_concat

會自動將那個column 的value 用 ',' group

完全救左我~!!

SELECT Class, GROUP_CONCAT(Animal) AS Animal FROM Zoo GROUP BY Family;

table

Class   Animal

===========

Fish   Goldfish

Fish   Grouper

Mammal Tiger

Mammal Lion

Result:

Fish   Goldfish,Grouper

Mammal  Tiger,Lion