第1个回答 2013-10-15
SELECT * FORM tables WHERE `price ` between 1000 and 2000
between and 是包含1000和2000
或者
SELECT * FORM tables WHERE `price `>1000 and `price `<2000
第2个回答 2017-12-15
price>1000 and price<2000
price between 1000 and 2000(1000<=price<2000 )
第3个回答 推荐于2017-04-22
SELECT * FORM tables WHERE price > 10000 and price < 20000本回答被提问者采纳