MySQL Results as comma separated list

by

You can use GROUP_CONCAT to perform that, e.g. something like

SELECT p.id, p.name, GROUP_CONCAT(s.name) AS site_list
FROM sites s
INNER JOIN publications p ON(s.id = p.site_id)
GROUP BY p.id, p.name;

More Related Contents:

  1. How to use GROUP BY to concatenate strings in MySQL?
  2. You can’t specify target table for update in FROM clause
  3. Generating a range of numbers in MySQL
  4. generate days from date range
  5. How can I combine multiple rows into a comma-delimited list in Oracle? [duplicate]
  6. Concatenate row values T-SQL
  7. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  8. MIN/MAX vs ORDER BY and LIMIT
  9. How can I merge two MySQL tables?
  10. Can table columns with a Foreign Key be NULL?
  11. Oracle SQL, concatenate multiple columns + add text
  12. Mysql recursion?
  13. is there a group_concat function in ms-access?
  14. Is there an alternative to TOP in MySQL?
  15. How many rows in a database are TOO MANY?
  16. Concatenate and group multiple rows in Oracle [duplicate]
  17. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  18. Is it possible to have an indexed view in MySQL?
  19. mysql – how many columns is too many?
  20. Best database field type for a URL
  21. Use A Union Or A Join – What Is Faster [closed]
  22. MySQL – how to front pad zip code with “0”?
  23. Find the number of columns in a table
  24. Mysql, reshape data from long / tall to wide
  25. MySQL: Compare differences between two tables
  26. Mysql strip time component from datetime
  27. How do I start auto increment from a specific point?
  28. How important are lookup tables?
  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