# Binary Operators

> Binary operators are used in where clause predicates to perform the indicated operation on two operands. The result is boolean true or false.

> ## Syntax

>         select * from ...
>         where val1 operator val2

> The eXtremeSQL binary operators are the following:

> = | Equal to
> <> | Not equal to
> < | Less than
> <= | Less than or equal
> > | Greater than
> >= | Greater than or equal

> ## Examples

>         create table t(i integer, d date);
>         insert into t values([3,5],['2017-01-01','2017-02-01']);

>         select * from t where i = 1 or i = 3;
>         i       d
>         ------------------------------------------------------------------------------
>         3       01/01/2017 00:00:00

>         Selected records: 1

>         select * from t where d < '2017-01-30';
>         i d
>         ------------------------------------------------------------------------------
>         3 01/01/2017 00:00:00

>         select * from t2 where i <> 3;
>         i       d
>         ------------------------------------------------------------------------------
>         5       02/01/2017 00:00:00

>         Selected records: 1