如何在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-13here 1E-13 means precision delta (you can adjust it, of cause) and $value is searched value
更多推荐
发布评论