mysql中and和or的查询优先级说明

cxSmiles

已于 2024-08-20 15:32:32 修改

阅读量815

点赞数 4

文章标签： mysql 数据库

于 2024-08-20 13:49:52 首次发布

本文链接：https://blog.csdn.net/qq_42000061/article/details/141059937

版权

mysql在and和or条件中会先执行and、再执行or，如果存在括号会先执行括号中的条件



SELECT * FROM _default WHERE `字段1` = xxx OR `字段2` = xxx AND `字段3` = xxx OR `字段4` = xxx AND `字段5` = xxx;
等价于
SELECT * FROM _default WHERE `字段1` = xxx OR (`字段2` = xxx AND `字段3` = xxx) OR (`字段4` = xxx AND `字段5` = xxx);


SELECT * FROM _default WHERE `字段1` = xxx OR `字段2` = xxx AND `字段3` = xxx OR `字段4` = xxx;
等价于
SELECT * FROM _default WHERE `字段1` = xxx AND `字段3` = xxx OR `字段2` = xxx OR `字段4` = xxx;