Boggled by GROUP_CONCAT in query...

[Antivirus]

eikin,
Thanks for the help. I can get it to work your way, but I really wanted to avoid using an additional table for the joins. I was however able to get the query to work using the following:

[SQL]
SELECT things.*, GROUP_CONCAT(stuff.code ORDER BY stuff.code SEPARATOR ', ') AS thingcodes
FROM things
LEFT JOIN stuff ON FIND_IN_SET(stuff.stuffid, things.stringcodeids) > 0
WHERE things.thingid = 2
GROUP BY things.thingid
[/SQL]

Is this really that much more inefficient than using an additional table to handle the stringcodeids -> stuffcode relationship?
Thanks again