How to use GROUP_CONCAT in mysql

By | January 10, 2017

GROUP_CONCAT() function is used to concatenate column values into a single string.

The following illustrates the GROUP_CONCAT function:

SELECT GROUP_CONCAT(country SEPARATOR ‘;’) FROM customers ORDER BY country;

Leave a Reply

Your email address will not be published. Required fields are marked *