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






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. Equal
mysql>
mysql>
mysql>
mysql> SELECT '0.0' = 0;
+-----------+
| '0.0' = 0 |
+-----------+
|         1 |
+-----------+
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;