Advance Searching Help!

[treworld]

Hi,

I've created a profiles search page at http://www.findacupid.com/search.php. My problem is to get it working properly...

The problem I'm having with are the checkboxes. The checkboxes values are stored in sequential order. For example: the field "lookingfor" has the values "1 2 3 4 5 6 12 14". How would I search for values "2" and "12" in that field?

I was thinking of doing something like this:

SELECT * FROM users WHERE lookingfor='%2%%12%'

It would search for the first value, but not the second or third or fourth.

Can someone help me, please?

Thanks! 🙂