如何在mysql中实现double数据类型的相等/近似条件？(How to implement equal/approximate condition for double datatype in m

如何在mysql中实现double数据类型的相等/近似条件？(How to implement equal/approximate condition for double datatype in mysql?)

我有一个表有一列double数据类型。 我想通过比较双值来选择行。 如果double列中不存在确切的值，我想获取包含double值的行，这些行是相等或最接近/近似的。

select * from tablename where DoubleColumnName equal/approx "some double value"

I have a table with one column of double datatype. I want to select rows by comparing against double value. If there is not exact value exist in the double column, I want to fetch rows containing double value which are equal or closest/approximate.

select * from tablename where DoubleColumnName equal/approx "some double value"

最满意答案

你可以实现这一目标

SELECT * FROM tablename WHERE ABS(DoubleColumnName-$value)<1E-13

这里1E-13表示精确增量（您可以调整它，原因）和$ value是搜索值

You can achieve that with

SELECT * FROM tablename WHERE ABS(DoubleColumnName-$value)<1E-13

here 1E-13 means precision delta (you can adjust it, of cause) and $value is searched value