Operator       Description
=                   Equal
<>                 Not equal
>                   Greater than
<                   Less than
>=                Greater than or equal
<=                Less than or equal
BETWEEN  Between an inclusive range
LIKE            Search for a pattern
IN                If you know the exact value you want to return for at least one of the columns