How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?

by

I’ve worked around this using SUBSTRING_INDEX.

For example:

SELECT SUBSTRING_INDEX(GROUP_CONCAT(Field1 SEPARATOR ','), ',', [# of elements to return])
FROM Table1;

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. Why does MYSQL higher LIMIT offset slow the query down?
  3. MySQL and GROUP_CONCAT() maximum length
  4. How to use GROUP_CONCAT in a CONCAT in MySQL
  5. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  6. What is the opposite of GROUP_CONCAT in MySQL?
  7. MySQL DISTINCT on a GROUP_CONCAT()
  8. Using variable in a LIMIT clause in MySQL
  9. Maximum number of records in a MySQL database table
  10. Combining UNION and LIMIT operations in MySQL query
  11. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  12. GROUP_CONCAT ORDER BY
  13. MySQL – UPDATE query with LIMIT
  14. GROUP_CONCAT with limit
  15. How to set a maximum execution time for a mysql query?
  16. MySQL: Sort GROUP_CONCAT values
  17. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  18. MySQL JOIN with LIMIT 1 on joined table
  19. How create json format with group-concat mysql?
  20. MySql Query: Select top 3 rows from table for each category
  21. Mysql delete statement with limit
  22. GROUP_CONCAT equivalent in Django
  23. UPDATE with ORDER BY and LIMIT not working in MYSQL
  24. MySQL LIMIT on DELETE statement
  25. is there a length limit to group_concat or another reason why it would not work on a text field
  26. Trouble with GROUP_CONCAT and Longtext in MySQL
  27. How should I resolve –secure-file-priv in MySQL?
  28. node-mysql multiple statements in one query
  29. How can I access the MySQL command line with XAMPP for Windows?
  30. Mysql covering vs composite vs column index

Leave a Comment