mysql GROUP_CONCAT duplicates

by

You need to use the DISTINCT option:

GROUP_CONCAT(DISTINCT animal)

More Related Contents:

  1. MySQL: GROUP_CONCAT with LEFT JOIN
  2. Join vs. sub-query
  3. Find records from one table which don’t exist in another
  4. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  5. Natural Sort in MySQL
  6. MySQL get row position in ORDER BY
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. MySQL unknown column in ON clause
  10. MySQL not using indexes with WHERE IN clause?
  11. SQL: Find the max record per group [duplicate]
  12. Group by month and year in MySQL
  13. Concatenate and group multiple rows in Oracle [duplicate]
  14. calculate a sum of type time using sql
  15. MySQL: Transactions vs Locking Tables
  16. Remove duplicates using only a MySQL query?
  17. Group by date only on a Datetime column
  18. Finding the next available id in MySQL
  19. How exactly does using OR in a MySQL statement differ with/without parentheses?
  20. MySQL: How to copy rows, but change a few fields?
  21. How to renumber primary index
  22. Query that ignore the spaces
  23. GROUP_CONCAT in SQLite
  24. mysql automatically store record creation timestamp
  25. How to convert from varbinary to char/varchar in mysql
  26. update columns values with column of another table based on condition [duplicate]
  27. I want to copy table contained from one database and insert onto another database table
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment