group_concat - MySQL
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.