Sql Select Query Question. Merge Rows

Question

I have a single MYSQL Question and need help ASAP. Database:

-------------------------------------------------------------------
Email                 | Name                      | Tag
-------------------------------------------------------------------
[email protected]         |Test Person               | TagOne
[email protected]         |Test Person               | Tag Two
-------------------------------------------------------------------

Need an SQL query that will return

-------------------------------------------------------------------
Email                 | Name                      | Tag
-------------------------------------------------------------------
[email protected]         |Test Person               | TagOne, Tag Two
-------------------------------------------------------------------

Any help?

Answer 1

Use:

  SELECT t.email,
         t.name,
         GROUP_CONCAT(DISTINCT t.tag ORDER BY t.tag SEPARATOR ', ')
    FROM YOUR_TABLE t
GROUP BY t.email, t.name

Reference:

• GROUP_CONCAT

Answer 2

For anyone else trying to do this and is stuck spending hours for a solution:

SELECT Email, Name, GROUP_CONCAT(Tag ORDER BY Tag ASC SEPARATOR ', ') FROM Table GROUP BY Email