is there a length limit to group_concat or another reason why it would not work on a text field

by

The group_concat result length is limited(truncated) to the value of the group_concat_max_len system variable. The default value of this variable is 1024.

If you want change the value of the variable the syntax is: 

SET [GLOBAL | SESSION] group_concat_max_len = val;

More info Mysql 5 docs

More Related Contents:

  1. Can I concatenate multiple MySQL rows into one field?
  2. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  3. How create json format with group-concat mysql?
  4. SQL Query needed for fetch value from Two identical table but not fully identical table
  5. How to create a MySQL hierarchical recursive query?
  6. Error related to only_full_group_by when executing a query in MySql
  7. How to reset AUTO_INCREMENT in MySQL
  8. How to declare a variable in MySQL?
  9. MySQL Query GROUP BY day / month / year
  10. MySQL Cannot Add Foreign Key Constraint
  11. Grouping into interval of 5 minutes within a time range
  12. SQL counting all rows instead of counting individual rows
  13. Convert timestamp to date in MySQL query
  14. MySQL Like multiple values
  15. In MySQL, should I quote numbers or not?
  16. MySQL add days to a date
  17. MySQL: Sort GROUP_CONCAT values
  18. mysql dynamic query in stored procedure
  19. Check for x consecutive days – given timestamps in database
  20. How to alter a column and change the default value?
  21. How to select one row randomly taking into account a weight?
  22. MySQL – Replace Character in Columns
  23. Sort the rows according to the order specified in WHERE IN clause
  24. update a column by subtracting a value
  25. mysql count group by having
  26. SQL UPDATE with sub-query that references the same table in MySQL
  27. How to store a one to many relation in MySQL database?
  28. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment