Mysql: How to get every rows that have more than a certain number of decimal after the dot

Question

I have a table that contains float values.

table

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

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

The result I would expect is:

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

Answer 1

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

Answer 2

This worked for me:

SELECT  *
FROM table
WHERE column <> ROUND (column,2)

or:

SELECT  *
FROM table
WHERE column <> CAST (column AS DECIMAL(36,2))