WHERE logic

[Anon]

Here is my where statement:

WHERE (name IN ('PHP', 'JavaScript') AND pri=1) OR (name IN ('C++', 'DHTML') AND pri=0 )

What I would like to happen is for it to match the right side of the or statement only if the
left side evaluates to true. But, I haven't found an operator that can help me with this.

Any suggestions?
matt

[Anon]

Am I missing something? What's wrong with using "AND" ?

• Gary