1.SELECT wu_price FROM la_debt_wu WHERE wu_price +0 BETWEEN '2.444'AND'6.666';
SELECT wu_price FROM la_debt_wu WHERE wu_price BETWEEN '2.444'AND'6.666';
区别如上,具体原因不知道,类型是varchar,先记住怎么用吧!!!
1.SELECT wu_price FROM la_debt_wu WHERE wu_price +0 BETWEEN '2.444'AND'6.666';
SELECT wu_price FROM la_debt_wu WHERE wu_price BETWEEN '2.444'AND'6.666';
区别如上,具体原因不知道,类型是varchar,先记住怎么用吧!!!