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