group_concat - MySQL

13 Jun 2013 http://mahmudahsan.wordpress.com/2008/08/27/mysql-the-group_concat-function/

This seems like it will be super useful.

If you're using "group by" and you still want to get data out of the grouped rows, then you can use this to combine multiple rows into a single row.