SELECT '0.01' = 0; : Equal « Comparison Functions Operators « MySQL Tutorial






mysql>
mysql> SELECT '0.01' = 0;
+------------+
| '0.01' = 0 |
+------------+
|          0 |
+------------+
1 row in set (0.00 sec)








15.4.Equal
15.4.1.Equal: =
15.4.2.Type conversion when using the Equal operator
15.4.3.SELECT '0.0' = 0;
15.4.4.SELECT '0.01' = 0;
15.4.5.SELECT '.01' = 0.01;