How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
Posted
by Misier
on Stack Overflow
See other posts from Stack Overflow
or by Misier
Published on 2009-10-05T21:30:21Z
Indexed on
2010/05/05
12:28 UTC
Read the original article
Hit count: 172
I somehow need this feature,but MySQL doesn't support it at this moment.
I'm using GROUP_CONCAT(CONCAT(...))
to generate a xml-like stuff.
But when the size exceeds the limit,the xml is just broken!
So I have to somehow make it only retrieve 5 rows !
© Stack Overflow or respective owner