Details
-
New Feature
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
-
None
Description
It would be nice to have a UDF like CONCAT for GROUP BY.
For example,
SELECT user, CONCAT(post) AS posts
FROM tablename
GROUP BY user
...which would return all of the posts concatenated together, separated by a single whitespace. So if the table was like this:
user\tpost
1\tHi there this is my first post
1\tpost number two
2\tI'm a different user!
then the above code would return
user\tposts
1\tHi there this is my first post post number two
2\tI'm a different user!
Alternate form:
CONCAT(string text, string separator) which would put the separator between each block of text.