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

[CrocoDillon]

I’m not an expert on database design but like @traq said for many-to-many relationships you’ll need a 3rd (association) table like (simplified):

CREATE TABLE event_options (
id INT,
event_id INT,
option_id INT
)

…with constraints and indices.