MySQL - Not equal to (<>) Operator

The MySQL <> (not equal to) operator checks if the value of left operand is not equal to the value of right operand and returns true if the condition is true, false otherwise.

Syntax

The syntax for using not equal to operator in MySQL is given below:

expression <> expression  

Parameters

Example 1:

The example below shows the usage of not equal to operator:

mysql> SELECT 10 <> 10;
Result: 0

mysql> SELECT 10.0 <> 10;
Result: 0

mysql> SELECT 10 <> 20;
Result: 1

mysql> SELECT 'abc' <> 'abc';
Result: 0

mysql> SELECT 'abc' <> 'xyz';
Result: 1

Example 2:

Consider a database table called Employee with the following records:

To select records of table where Age of the person is not equal to 28, the query is given below.

SELECT * FROM Employee
WHERE Age <> 28;

The query will produce following result: