Not equal: <> or != : Not equal « Comparison Functions Operators « MySQL Tutorial

1. MySQL Tutorial
2. Comparison Functions Operators
3. Not equal

mysql>
mysql>
mysql> SELECT 1 <> 2;
+--------+
| 1 <> 2 |
+--------+
|      1 |
+--------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql>