Articles/SQL

GROUP_CONCAT() in MySQL — How It Works

What the MySQL GROUP_CONCAT() function does, with an example.

Published October 21, 2026

GROUP_CONCAT() concatenates values from multiple rows within a group into a single string.

Key points

  • Part of standard SQL functions available in MySQL for working with text/strings

Example

SELECT GROUP_CONCAT(name SEPARATOR ', ') FROM tags;
More SQL articles