[SOLVED] dumb question

[dadamssg]

if i have a column title category. How would i query for multiple categories? i know that this will pull up only 'sports'.

 

SELECT * FROM test WHERE event = 'sports' ORDER BY start ASC LIMIT 5

 

whats the correct syntax for doing something like this

 

SELECT * FROM test WHERE event = 'sports','performance','random' ORDER BY start ASC LIMIT 5

 

??

[trq]

SELECT * FROM test WHERE event IN('sports','performance','random') ORDER BY start ASC LIMIT 5

[dadamssg]

thank you!