How to use GROUP_CONCAT in mysql

By | 10th January 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 e-mail address will not be published. Required fields are marked *