Comparison Operators

These operations test whether two expressions are equal. Comparison Operators result in a value of true, false or null. The following tables show the usual comparison operators that can be used for all simple data types:

Operator	Description
<	less than
>	greater than
<=	less than or equal to
>=	greater than or equal to
=	equal
<>	not equal
!=	not equal - same as <>

If used in the WHERE Clause the following operators are valid in addition.

Operator	Description
LIKE	matches a part of the given value
NOT	negates a condition
IS NULL	matches a NULL value
IS NOT NULL	matches a Non-NULL value
~	regular expression match
!~	negated regular expression match
between	`a BETWEEN x and y`: shortcut for `a >= x AND a <= y`