MySQL DISTINCT on a GROUP_CONCAT()

by

GROUP_CONCAT has DISTINCT attribute:

SELECT GROUP_CONCAT(DISTINCT categories ORDER BY categories ASC SEPARATOR ' ') FROM table

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. MySQL and GROUP_CONCAT() maximum length
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  5. What is the opposite of GROUP_CONCAT in MySQL?
  6. GROUP_CONCAT ORDER BY
  7. GROUP_CONCAT with limit
  8. MySQL: Sort GROUP_CONCAT values
  9. How create json format with group-concat mysql?
  10. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  11. GROUP_CONCAT equivalent in Django
  12. is there a length limit to group_concat or another reason why it would not work on a text field
  13. Trouble with GROUP_CONCAT and Longtext in MySQL
  14. Check if MySQL table exists without using “select from” syntax?
  15. How to see log files in MySQL?
  16. Differences between utf8 and latin1
  17. MySQL stored procedures use them or not to use them
  18. Using SQL LIKE and IN together
  19. SQL query of multiple values in one cell
  20. MySQL floating point comparison issues
  21. How to retrieve the current version of a MySQL database management system (DBMS)?
  22. Using ALTER to drop a column if it exists in MySQL
  23. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  24. Meaning of “n:m” and “1:n” in database design
  25. How to force case sensitive table names?
  26. MySQL concat() to create column names to be used in a query?
  27. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  28. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  29. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  30. Get column sum and use to calculate percent of total (mySQL)

Leave a Comment