mysql select distinct rows into a comma delimited list column

by

Use GROUP_CONCAT() for this, with a GROUP BY covering the other three columns:

SELECT 
  name,   -- Microsoft
  other,  -- GGG
  other2, -- 1
  GROUP_CONCAT(id) AS ids
FROM tbl
GROUP BY name, other, other2

More Related Contents:

  1. Getting the SUM() of claps and at the same time counting bookmarks in one query
  2. mysql – I dont understand what this means, can anyone explain each line of the script to me? [closed]
  3. How to filter SQL results in a has-many-through relation
  4. Return row only if value doesn’t exist
  5. How to delete from multiple tables in MySQL?
  6. INSERT with SELECT
  7. How to get list of dates between two dates in mysql select query [duplicate]
  8. mysql update column with value from another table
  9. difference between primary key and unique key
  10. Illegal mix of collations MySQL Error
  11. SQL query: Delete all records from the table except latest N?
  12. SQL order string as number
  13. Rename a column in MySQL
  14. Find most frequent value in SQL column
  15. How to convert number of week into date?
  16. update multiple rows using limit in mysql?
  17. Mysql 1050 Error “Table already exists” when in fact, it does not
  18. How to get the latest record in each group using GROUP BY? [duplicate]
  19. SQL Query to get column values that correspond with MAX value of another column?
  20. When to use SELECT … FOR UPDATE?
  21. Setting column values as column names in the SQL query result
  22. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  23. SQL unique varchar case sensitivity question
  24. How to get current date & time in MySQL?
  25. How do I count columns of a table
  26. Laravel join with 3 Tables
  27. How to regex in a MySQL query
  28. Why MySQL is giving error “Not allowed to return a result set from a function”?
  29. MySQL 5.6 – DENSE_RANK like functionality without Order By
  30. Syntax error on MERGE statement

Leave a Comment