multiple posabilities in cell

[frans-jan]

Hi,

I've build a query from a php form where people van select more results for a cell wich can only contain one value

Here's my query

SELECT * FROM person WHERE color_eye = ('brown') OR color_eye = ('black') AND color_hair = ('Blonde')

Everything after the "OR" will be ingnored. So how can I tell MySQL I want all the brown and blacked eye??

Without the AND it works fine, but in real the query is way longer with multiple AND's

anybody?

[Anon]

Try with braces:

SELECT * FROM person WHERE color_eye = ('brown') OR ( color_eye = ('black') AND color_hair = ('Blonde') )

[Anon]

Aren´t you just forgetting parenthesis:

SELECT * FROM person WHERE (color_eye = ('brown') OR color_eye = ('black')) AND color_hair = ('Blonde')

[frans-jan]

Yes I was...

Thank you all for this superfast reply!