在MySQL中选择一个float [英] Selecting a float in MySQL
问题描述
我想根据标识符和价格对表进行 SELECT
匹配,例如:
I am trying to do a SELECT
match on a table based upon an identifier and a price, such as:
SELECT * FROM `table` WHERE `ident`='ident23' AND `price`='101.31';
< '位返回正确的行。
执行...
SELECT * FROM `table`;
返回与上述相同的行,并清楚地说明 price ='101.31 '
。然而选择失败匹配它。将 = 更改为
< =
可以使其正常工作,但这不是一个解决方案。
Returns the same row as above and quite clearly states that price='101.31'
. Yet select fails to match it. Changing =
to <=
makes it work - but this is not exactly a solution.
有一种方法可以在对其执行操作之前将MySQL浮点数转换为2位数,从而使上述 SELECT
工作一些其他解决方案)?
Is there a way of casting the MySQL float to 2 digits before the operation is performed on it, thus making the above SELECT
work (or some other solution)?
谢谢!
推荐答案
decimal为我工作:
Casting to a decimal worked for me:
SELECT * FROM table WHERE CAST(price AS DECIMAL) = CAST(101.31 AS DECIMAL);
< $ c> column a DECIMAL在第一位。 DECIMAL通常被认为是处理货币价值时最好的类型。
However, you may want to consider just making the price
column a DECIMAL in the first place. DECIMAL is generally considered to be the best type to use when dealing with monetary values.
这篇关于在MySQL中选择一个float的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!