Comparison Functions and Operators For row comparisons,  (a, b) <=> (x, y)  is equivalent to: (a <=> x) AND (b <=> y) mysql>  SELECT ’.01’ <> ’0.01’; -> 1 mysql>  SELECT .01 <> ’0.01’; -> 0 mysql>  SELECT ’zapp’ <> ’zappp’; -> 1 Not equal: • <> ,  != • <= • < • >= • > 2127 (a > x) OR ((a = x) AND (b > y)) mysql>  SELECT 2 > 2; -> 0 (a > x) OR ((a = x) AND (b >= y)) mysql>  SELECT 2 >= 2; -> 1 (a < x) OR ((a = x) AND (b < y)) mysql>  SELECT 2 < 2; -> 0 (a < x) OR ((a = x) AND (b <= y)) mysql>  SELECT 0.1 <= 2; -> 1 (a <> x) OR (b <> y) For row comparisons,  (a, b) <> (x, y)  and  (a, b) != (x, y)  are equivalent to: Less than or equal: For row comparisons,  (a, b) <= (x, y)  is equivalent to: Less than: Greater than or equal: For row comparisons,  (a, b) < (x, y)  is equivalent to: For row comparisons,  (a, b) >= (x, y)  is equivalent to: Greater than: For row comparisons,  (a, b) > (x, y)  is equivalent to: