带 between and 的范围查询
1,SELECT 字段 1,字段 2,字段 3...FROM 表名 WHERE 字段 [NOT] BETWEEN 取值 1 AND 取值 2;
eg:查询年龄在21和24之间的学生信息
select * from t_student where age between 21 and 24;
eg:查询年龄不在21和24之间的学生信息
select * from t_student where age not between 21 and 24;