Compares two expressions for equivalence, and returns a true value if they are found to be unequal.

Syntax

expression <> expression

Arguments

  • expression: an expression.

Examples

SELECT * FROM MYSQL.inventory.cust WHERE lastName <> 'Smith';

VALUES 'John' <> 'Tom';
-- Returns true