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

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

• <> , != 

Not equal: 

mysql> SELECT ’.01’ <> ’0.01’; -> 1 mysql> SELECT .01 <> ’0.01’; -> 0 mysql> SELECT ’zapp’ <> ’zappp’; -> 1 

For row comparisons, (a, b) <> (x, y)  and (a, b) != (x, y)  are equivalent to: 

(a <> x) OR (b <> y) 

• <= 

Less than or equal: 

mysql> SELECT 0.1 <= 2; -> 1 

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

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

• < 

Less than: 

mysql> SELECT 2 < 2; -> 0 

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

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

• >= 

Greater than or equal: 

mysql> SELECT 2 >= 2; -> 1 

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

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

• > 

Greater than: 

mysql> SELECT 2 > 2; -> 0 

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

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

