Re: mySQL: Query two tables for multiple results from array in first table?

[Presto]

So I was able to get it to work by replacing **WHERE IN** with **FIND_IN_SET**:

“SELECT e.*, (SELECT GROUP_CONCAT(DISTINCT o.title SEPARATOR ‘,’) FROM #__raceschedule_options AS o WHERE FIND_IN_SET(o.id, e.options)) optiontitles FROM `#__raceschedule_events` AS e”