Mysql:如何获取点后小数位数超过一定数量的每一行 [英] Mysql: How to get every rows that have more than a certain number of decimal after the dot

问题描述

我有一个包含浮点值的表.

I have a table that contains float values.

+   id   |  value  |
+--------|---------|
+   1    | 19.22   |
+   2    | 32.333  |
+   3    | 1.2332  |
+   4    | 0.22334 |
+   5    | 4.55    |

我想提取点后每行包含多于3个小数的行.

I want to extract every row that contains more than 3 decimal after the dot.

+   id   |  value  |
+--------|---------|
+   2    | 32.333  |
+   3    | 1.2332  |
+   4    | 0.22334 |

推荐答案

将value列作为varchar并使用字符串比较.

Cast the value column as a varchar and use string comparison.

这篇关于Mysql:如何获取点后小数位数超过一定数量的每一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！