Priority

[Anon]

Hello,

How can I say to mysql, that I want to check the columns with priority.
A.g.: a=1 and b=2 or c=3
It can means two things.
1: a and b or c
2: a and b or a and c

Hope you understand me.

//Ulrik Q K

[Anon]

Use parentheses? Is that what you are looking for?

(a=1) AND (b=2 OR c=3);
(a=1 AND b=2) OR (a=1 AND c=3);

these are basically the same, and I think what you were after??

Chris King