GROUP_CONCAT
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. Using SEPARATOR string value, We get inserted separator between values of result. The default is a comma (‘,’). You can eliminate the separator altogether by specifying SEPARATOR ‘’.
Syntax:
GROUP_CONCAT([col_name] SEPARATOR [str]);
Example:
SELECT keyword, GROUP_CONCAT(other_score SEPARATOR ‘|’) FROM wordlist GROUP BY keyword;
