confusion with where query and arrays

[eluser]mddd[/eluser]
In that kind of case, I would use a link table to store the relationships between the items and the colours. That solves the problem. It gives you more flexibility in searching and storing (e.g. you can store any number of colors for an item).