Compares two expressions, and returns true if the first value is less than the second value.

Syntax

expression < expression

Arguments

  • expression: an expression.

Examples

SELECT * FROM MYSQL.inventory.cust WHERE grossPay < 100000;

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