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. The full syntax is as follows:

Very useful MySQL function.

MySQL AB :: MySQL 5.0 Reference Manual :: 11.11.1 GROUP BY (Aggregate) Functions