Problem with a search system

[nomad9]

Hi!

Got a select list that allow user to select color. They can select multiple choice.

So, for USER1, field COLOR may look like this : a|b|c (I use this syntax to store choice as an array)

Now, i want to allow ADMIN to do search for COLOR.

My question is that, if for example I want to find all USER with a|c choice, i'll used ... WHERE COLOR LIKE '%a%' AND COLOR LIKE '%c%'

Did someone have a better idea to do that

thank