Comparison Operators

Comparison operators are available for all data types where comparison makes sense. All comparison operators are binary operators that return values of True, False, or NULL.

Syntax and Parameters

<

>

<=

>=

= or <=>

<> or !=

Notes

• The comparison operators return NULL (signifying "unknown") when either operand is null.
• The <=> operator performs an equality comparison like the = operator, but it returns true, instead of NULL, if both operands are NULL, and false, instead of NULL, if one operand is NULL.