Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id foo_name 1 A B 2 C 6 Answers 6 Tags: aggregateconcatenationMySQLsqlstring