说明

范围查询，包头又包尾

between and

例子
查询用户编号大于等于3并且小于等于6的用户

  1. select * from tb_user where id between 3 and 6;

not between and

查询不在这个范围的数据
例子
查询用户编号小于3或者大于6的用户

select * from tb_user where id not between 3 and 6;