Data type conversion in Not equal operator : Not equal « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. Not equal
mysql>
mysql> SELECT '.01' <> '0.01';
+-----------------+
| '.01' <> '0.01' |
+-----------------+
|               1 |
+-----------------+
1 row in set (0.00 sec)








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