SELECT * FORM tables WHERE `price ` between 1000 and 2000
between and 是包含1000和2000
或者
SELECT * FORM tables WHERE `price `>1000 and `price `<2000
price>1000 and price<2000
price between 1000 and 2000(1000<=price<2000 )
SELECT * FORM tables WHERE price > 10000 and price < 20000
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024