MySQL模糊查询—between and关键字

BETWEEN AND

• 提高简洁度
• between a and b 包含[a,b]

案例1：查询员工编号在100-120之间的员工信息

USE myemployees;

SELECT
    *
FROM
    employees
WHERE
    # employee_id >=100 and employee_id <= 120;
    employee_id BETWEEN 100 AND 120;