Grouping "OR" statements in MySQL? Howto?

[acidbox]

• NT - (mispost)

[Sxooter]

Are you looking at something like:

select * from table
where
(field1='x' OR field2='y' OR field3='z')
AND
(field1='y' OR field2='z' OR field3='a')
;

[acidbox]

yes, that was it, but i figured it out right after i posted heh