[RESOLVED] Query - Selecting a row from only part of a field

[joshmpratt]

I've got a database for storing events. I've got a field in my events table called 'shown_areas'. There are multiple areas that each event might be displayed in, so my thought is to list each area that it is to be shown seperated by commas. (Ex: registrations, recreation, men) I'm not sure if this is a good method or not, and if anyone has a better suggestion, I'm open to it.

But, if this is an 'ok' way to do it, I'm wondering how I would do my query:

SELECT * FROM events WHERE (now it should say something like 'shown_areas contains 'registrations' or something like that?)

Any help would be appreciated!

[bogu]

SELECT * FROM events WHERE shown_areas LIKE '%registrations%'

Something like this ...

[joshmpratt]

Thank you!! Works perfectly.