Compare string value using the Not equal operator : Not equal « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. Not equal
mysql>
mysql> SELECT 'AB' <> 'ABC';
+---------------+
| 'AB' <> 'ABC' |
+---------------+
|             1 |
+---------------+
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