SELECT id, GROUP_CONCAT(string SEPARATOR ' ') FROM table GROUP BY id;
From the link above,
GROUP_CONCAT
: This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.