MySQL中BETWEEN是包含两边界值的,表示在此范围内,并且包含此值
SELECT
* FROM users WHERE user_id BETWEEN
1 AND
3
=》SELECT * FROM users WHERE user_id >=1 AND user_id <=3 2. MySQL中NOT BETWEEN 是不包含两个边界的,表示不在此范围内
SELECT
* FROM users WHERE user_id NOT BETWEEN
2 AND
4
=》SELECT * FROM users WHERE user_id <2 AND user_id >4