Type conversion when using the Equal operator : Equal « Comparison Functions Operators « MySQL Tutorial






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