[FX.php List] AND plus OR search

[Anders Monsen]

I think my mysql background is clouding my FX attempts...

Is it possible to search for something where the conditions are as  
follows:

where field A contains value 'X'
	and

field B contains value 'Y'
	or
field C contains value 'X'

I believe a pure OR search would find across A or B or C having the  
values, but I want to have field A and then one of the other two fields.

--
Thanks,
Anders Monsen