between and范围关键字
SELECT * FROM table_name WHERE id [NOT] BETWEEN 取值1 AND 取值2