<

Less than:

Syntax

MYSQL Copy

SELECT 2 < 2;
0

Examples

Example

For row comparisons, (a, b) < (x, y) is equivalent to:

MYSQL Copy

SELECT 2 < 2;
0

Example 2

MYSQL Copy

(a < x) OR ((a = x) AND (b < y))