How To Use MySQL’s GROUP_CONCAT To Get Aggregated Lists of Values
One of my favorite MySQL functions that I wished more people knew about is GROUP_CONCAT. This lets you create an aggregated list of values in your queries. Read on to learn how to use it.