中选择一个浮点数

中选择一个浮点数

本文介绍了在 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';

以上返回零行,而如果您删除 price='101.31' 位,它将返回正确的行.

The above returns zero rows, while if you remove the price='101.31' bit it returns the correct row.

做一个...

SELECT * FROM `table`;

返回与上述相同的行,并非常清楚地说明 price='101.31'.然而 select 无法匹配它.将 = 更改为 <= 使其工作 - 但这并不完全是解决方案.

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)?

谢谢!

推荐答案

强制转换为小数对我有用:

Casting to a decimal worked for me:

SELECT * FROM table WHERE CAST(price AS DECIMAL) = CAST(101.31 AS DECIMAL);

但是,您可能希望首先考虑将 price 列设为 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 中选择一个浮点数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 16:16