SQL WHERE Clause Predicates

Predicates boil down to either a TRUE or a FALSE result. You can filter out unwanted rows from the result of an SQL query by applying a WHERE clause whose predicate excludes the unwanted rows.

Comparison Predicates    

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

Other Predicates    

ALL	BETWEEN
DISTINCT	EXISTS
IN	LIKE
MATCH	NOT IN
NOT LIKE	NULL
OVERLAPS	SIMILAR
SOME, ANY	UNIQUE

Other Predicates    

ALL	BETWEEN
DISTINCT	EXISTS
IN	LIKE
MATCH	NOT IN
NOT LIKE	NULL
OVERLAPS	SIMILAR
SOME, ANY	UNIQUE

dummies

Source:http://www.dummies.com/how-to/content/sql-where-clause-predicates.html