MySQL Syntax

Display issues (e.g. not repeating a category name) are handled in your front end code (e.g. PHP), not in the MySQL query.

Hi!

This is what you are looking for.
If the columns of the table is Group and Genre then

select `group`, group_concat(genre, ',' ) 
from table
group by `group`

Select allOpen in new window

Note that the word group is a reserved word in all dbms systems so using that in a table or view could lead to parsing errors when executing sql statements.
http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

Regards,
     Tomas Helgi

Hi, group_concat(genre, ',' )  puts them next to eachother, how can I make them each on their own line?