15.MySQL中的BETWEEN（在某个范围）

目录

1.准备

2.BETWEEN…AND…

3.NOT BETWEEN…AND…

---

1.准备

CREATE DATABASE mahaiwuji;
USE mahaiwuji;

CREATE TABLE emp
(
	empno INT PRIMARY KEY,
	ename VARCHAR(10),
	sal INT
) ENGINE = INNODB DEFAULT CHARSET = utf8;

INSERT INTO emp VALUES (1,'smith',2800);
INSERT INTO emp VALUES (2,'allen',1500);
INSERT INTO emp VALUES (3,'ward',3500);
INSERT INTO emp VALUES (4,'jones',1300);
INSERT INTO emp VALUES (5,'martin',1600);
INSERT INTO emp VALUES (6,'blake',3000);

2.BETWEEN…AND…

比较一个数据是否在指定的闭区间范围内

-- 查询sal在1500和3000之间的数据（包括1500和3000）
SELECT * FROM emp WHERE sal >= 1500 AND sal <= 3000;
-- 等价于
SELECT * FROM emp WHERE sal BETWEEN 1500 AND 3000;