Have Geek Brain

SQL select query to concatenate rows

I have one MySQL database:

-------------------------------------------------------------------
Email                 | Name                      | Tag
-------------------------------------------------------------------
test@test.com         |Test Person               | TagOne
test@test.com         |Test Person               | Tag Two
-------------------------------------------------------------------

We need a SQL query that will return

-------------------------------------------------------------------
Email                 | Name                      | Tag
-------------------------------------------------------------------
test@test.com         |Test Person               | TagOne, Tag Two
-------------------------------------------------------------------

How can i do this?

+1


a source to share


2 answers


Using:

  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


Link:

+3


a source


For anyone trying to do this and stuck:



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


a source






More articles:


All Articles