Question

MYSQL语句中查询字段中大于某个数且小于某个数之间的条件怎么设定

例如我要查大于10000的数据就是

SELECT * FORM tables WHERE price > 10000;
小于10000就是
SELECT * FORM tables WHERE price > 10000;
现在我要查 大于1000小于2000的，就是 1000<price<2000怎么查？

Answer 1

SELECT * FORM tables WHERE `price ` between 1000 and 2000

between and 是包含1000和2000

或者

SELECT * FORM tables WHERE `price `>1000 and `price `<2000

Answer 2

price>1000 and price<2000
price between 1000 and 2000(1000<=price<2000 )

Answer 3

SELECT * FORM tables WHERE price > 10000 and price < 20000