All comparisons will return a boolean true or false.

== - equals, name='Smith' for example, or 1==2.

!= - not equal., name!='Smith', or 2!=1.

> - Greater than.

< - Lesser than.

>= - Greater or equal to.

<= - Less or equal to.

in - name in ('Smith','Jones') or cust_id in (1,2,3,4,5,'122') for example.