Priority of AND and OR operator in Mysql select query

Question

I have a written a mysql select query to fetch schedule details based on origin states,origin city,destination state and destination city. In my query i have used AND and OR operator.

Here is my query,

SELECT * FROM TruckLoadSchedule ts 
WHERE ts.originState IN (states) AND ts.originCity IN (cities) 
   OR ts.destState IN (states) AND ts.destCity IN (cities);

But I need to know the priority of AND and OR operator in the above query, i mean to say will it do something like this (X AND Y) OR (M AND Q) internally?

and why don't you just use the brackets? You can use brackets in sql! — luksch, Apr 27 '13 at 08:19
A forum is not a way to avoid using [documentation](https://dev.mysql.com/doc/refman/5.5/en/operator-precedence.html). — Álvaro González, Apr 27 '13 at 08:20

score 8 · Accepted Answer · answered Apr 27 '13 at 08:19

8

Yes, AND has higher precedence than OR. x and y are bound together, m and q are bound together, then the resulting expressions are ORed.

answered Apr 27 '13 at 08:19

Sam Dufel

17,560
3
48
51

so i don't need to add any extra bracket in my query?. I mean now it is like this x AND y OR M AND Q, if i add brackets it will be like this (x AND y) OR (M AND Q). – Kishan_KP Apr 27 '13 at 08:27
2

Brackets will probably help the readability, but it'll work fine without them. – Sam Dufel Apr 27 '13 at 08:29
That is implied by this answer. You don't need to keep asking the same question. – user207421 Apr 27 '13 at 08:29
@SamDufel Thnx for your answer and patience to explain the things. – Kishan_KP Apr 27 '13 at 08:32
@EJP There is nothing wrong in asking if you are not clear enough. – Kishan_KP Apr 27 '13 at 08:34
It's hard to see what part of 'yes' you didn't understand, or what part of 'higher precedence' either. – user207421 Apr 27 '13 at 10:43

score 1 · Answer 2 · answered Apr 27 '13 at 08:22

1

AND has a higher priority than OR in every programming language I have ever seen, and I've seen several dozen at close quarters, and implemented a few myself. This question was basically settled in 1960 with the Algol-60 report, if not already in Fortran (1957).

[There was one exception but it was a mis-implemented language with no operator precedence at all. I fixed that.]

answered Apr 27 '13 at 08:22

user207421

305,947
44
307
483

+1 for the thumb rule. – Álvaro González Apr 27 '13 at 08:25
1

@downvoter Some error above? – user207421 May 04 '13 at 07:52
@downvoter Seriously, what is the error here? AND isn't higher priority than OR? I haven't seen several dozen languages? Haven't implemented a few myself? (*Quite* a few.) What's the problem here? – user207421 May 17 '17 at 10:42

score 1 · Answer 3 · answered Apr 27 '13 at 08:24

1

Yes it will do something like (X AND Y) OR (M AND Q). AND operator's priority is higher than OR.

For more see MySQL: Operator Precedence

answered Apr 27 '13 at 08:24

Himanshu

31,810
31
111
133

Priority of AND and OR operator in Mysql select query

3 Answers3

Linked