MySQL Query GROUP_CONCAT Over Multiple Rows
- by PeteGO
I'm getting name and address data out of generic question / answer data to create some kind of normalised reporting database.
The query I've got uses group_concat and works for individual sets of questions but not for multiple sets.
I've tried to simplify what I'm doing by using just forename and surname and just 3 records, 2 for 1 person and 1…