mysql and or优先级

and优先级高于or,

不使用()情形:or后仍遇到and时,先算and再算or

select * from table1 where f1=1 and f2=2 or f3=3 and f4=4 or f5=5 等价于 select * from table1 where (f1=1 and f2=2) or (f3=3 and f4=4) or f5=5

原文：https://www.cnblogs.com/navigate/p/15196277.html