I was reading mahmud hasan blog and found a unknown function called GROUP_CONCAT().
“GROUP_CONCAT() function is used to concatenate column values into a single string. It is very useful if you would otherwise perform a lookup of many row and then concatenate them on the client end.
For example if you query:
mysql> SELECT Language FROM CountryLanguage [...]
Filed under: MYSQL | Tagged: group_concat | Leave a Comment »