Problem with AND and OR

[Anon]

How would I set up a query
to check to see something of this nature:

if (t1.item1=srch1 or t1.item2=srch1 or t1.item3=srch1)
and t1.item4=srch2 and t1.item5=srch3 and t1.item6=srch4;

I need it to check some OR's first, so I can have one item
I am searching for match any 3 fields, but then I must have
some successful AND's following the OR's, more than one AND.
All data is being used to check against one table. When I
try this like this

select * from t1 where t1.item1=srch1 or t1.item2=srch1 or
t1.item3=srch1 and t1.item4=srch2 and t1.item5=srch3 and
t1.item6=srch4;

It doesn't work.

Any ideas?

[Anon]

you may use some brackets?

[rogue]

Carl,

Why can't you just...

SQL> select *
2 from t1
3 where (item1 = srch1 or
4 item2 = srch1 or
5 item3 = srch1)
6 and item4 = srch2
7 and item5 = srch3;

?

smd