SELECT .01 <> '0.01'; : Not equal « Comparison Functions Operators « MySQL Tutorial






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

mysql>








15.13.Not equal
15.13.1.Not equal: <> or !=
15.13.2.Data type conversion in Not equal operator
15.13.3.SELECT .01 <> '0.01';
15.13.4.Compare string value using the Not equal operator
15.13.5.String comparisons are not case sensitive