GROUP_CONCAT_UNQUOTED
This function concatenates multiple strings into a single string, where each value is separated by the optional separator parameter. If separator is omitted, then this function returns a comma-separated string.
Syntax
GROUP_CONCAT_UNQUOTED('str' [, separator])
Example
SELECT
GROUP_CONCAT_UNQUOTED(x)
FROM (
SELECT
'a"b' AS x),
(
SELECT
'cd' AS x);
Unlike GROUP_CONCAT, this function will not add double quotes to returned values that include a double quote character. In the example above, the string a"b would return as a"b.