(基础)Mysql and和or 的优先级

背景

MySQL中，AND的执行优先级高于OR

写在前面
原文链接https://www.cnblogs.com/phpper/p/10773004.html
link

例子

优先执行AND语句，再执行OR语句

select * from table where  条件1 AND 条件2 OR 条件3
等价于
select * from table where  ( 条件1 AND 条件2 )  OR 条件3

select * from table where  条件1 AND  条件2 OR 条件3 AND 条件4
等价于
select * from table where (  条件1 AND  条件2  ) OR (  条件3 AND 条件4  )

因为mysql5.6所以去掉了CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci
表结构：
CREATE TABLE `book`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(25)  DEFAULT NULL,
  `author` varchar(25)   DEFAULT NULL,
  `price` decimal(10, 2) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB   ROW_FORMAT = Dynamic;

INSERT INTO `book` VALUES (1, 'PHP', 'mate', 21.00);
INSERT INTO `book` VALUES (2, 'JAVA', 'kaven', 23.00);
INSERT INTO `book` VALUES (3, 'JAVA高级', 'loose', 45.00);
INSERT INTO `book` VALUES (4, 'GO', 'jim', 46.00);
INSERT INTO `book` VALUES (5, 'GO设计', 'json', 76.00);
INSERT INTO `book` VALUES (6, 'PHP高级编程', 'bate', 67.00);
INSERT INTO `book` VALUES (7, 'Python', 'jim', 66.00);
INSERT INTO `book` VALUES (8, 'Python设计', 'mali', 54.00);
INSERT INTO `book` VALUES (9, 'GO编程', 'kaven', 86.00);
INSERT INTO `book` VALUES (11, 'Python3', 'jim', 55.00);

查询方式1：
SELECT * FROM book WHERE author='jim' OR author='json' AND name='PHP';
+----+---------+--------+-------+
| id | name    | author | price |
+----+---------+--------+-------+
|  4 | GO      | jim    | 46.00 |
|  7 | Python  | jim    | 66.00 |
| 11 | Python3 | jim    | 55.00 |
+----+---------+--------+-------+
上面的查询等价于：
SELECT * FROM book WHERE author='jim' OR (author='json' AND name='PHP');

查询方式2：
SELECT * FROM book WHERE name='PHP' AND author='jim' OR author='json';
+----+----------+--------+-------+
| id | name     | author | price |
+----+----------+--------+-------+
|  5 | GO设计   | json   | 76.00 |
+----+----------+--------+-------+
上面的查询等价于：
SELECT * FROM book WHERE (name='PHP' AND author='jim') OR author='json';

查询方式3：善用()改变优先级
SELECT * FROM book WHERE name='GO' AND (author='jim' OR author='json');

推荐阅读原文，有详细介绍

本文说明，主要技术内容来自互联网技术大佬的分享，还有一些自我的加工(仅仅起到注释说明的作用)。如有相关疑问，请留言，将确认之后，执行侵权必删​