SQL WHERE Clause Predicates

The WHERE clause is an SQL filter that passes rows that meet the search condition and rejects rows that don't meet the condition. By including WHERE clauses in your SQL SELECT statements, you can restrict the rows that you place into the resulting table to those that satisfy specific conditions. The following table lists the predicates to use to filter for the information you want:

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

dummies

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