sql help

[mykg4orce]

say i have the following table

id , emails
1, [e-mail]
1, [e-mail]
2, [e-mail]
2, [e-mail]

how can I write a select statement to ouput

1 [e-mail], [e-mail]
2 [e-mail], [e-mail]

[NogDog]

SELECT id, GROUP_CONCAT_WS(', ', emails) AS email_list FROM table_name GROUP BY id