Friday, April 20, 2007

MySQL - group_concat() - aggregate function for string concatenation UDF


MySQL UDF: group_concat() - aggregate function for string concatenation
MyGroupConcat: A MySQL UDF aggregate function for string concatenation (The Code Project/Database)

MySQL extension library provides an aggregate function that concatenate strings (for use with SELECT...GROUP BY clause).

Example:
SELECT group_concat(label) AS labelFROM test_group_concatGROUP BY LEFT(code, 3);