GROUP_CONCAT with limit

by

One somewhat hacky way to do it is to post-process the result of GROUP_CONCAT:

substring_index(group_concat(s.title SEPARATOR ','), ',', 3) as skills

Of course this assumes that your skill names don’t contain commas and that their amount is reasonably small.

fiddle

A feature request for GROUP_CONCAT to support an explicit LIMIT clause is unfortunately still not resolved.

UPDATE: As user Strawberry points out, the table player_skills should have the tuple (player_id, skill_id) as its primary key, otherwise the schema allows for the same skill to be assigned to a player multiple times, in which case group_concat would not work as expected.

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. MySQL DISTINCT on a GROUP_CONCAT()
  7. GROUP_CONCAT ORDER BY
  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. i have an error which i dont understand. can you help me? [closed]
  15. MySQL select 10 random rows from 600K rows fast
  16. How do you use the “WITH” clause in MySQL?
  17. Simulate lag function in MySQL
  18. mysql error 1364 Field doesn’t have a default values
  19. SQL: What is the default Order By of queries?
  20. MySQL Split Comma Separated String Into Temp Table
  21. Can I use a function for a default value in MySql?
  22. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  23. Get record counts for all tables in MySQL database
  24. How can I suppress column header output for a single SQL statement?
  25. Modeling Product Variants
  26. How do I refer to capture groups in a MySQL regex?
  27. What is the default MySQL JOIN behaviour, INNER or OUTER?
  28. How to get the mysql table columns data type?
  29. How to kill MySQL connections
  30. How to solve MySQL max_user_connections error

Leave a Comment