"Several weeks ago, I introduced the SQL WHERE clause as we
started discussing the uses of the SELECT statement; this week
we're going to drill a little deeper into the capabilities of the
WHERE clause to see what it can really do. It is especially
relevant now since we've discussed the UPDATE and DELETE statements
in the past couple of columns, which can (and generally should)
also use the WHERE clause. And as we'll see in future columns, some
of the operators of the WHERE clause can be used to do cool things
with other SQL clauses. So with no further ado, I give you:
the WHERE clause"
"The SQL WHERE clause accepts a number of comparison operators
(Table 1) and Boolean operators (Table 2) in virtually any
combination. They include the standard equality operators as well
as more specialized operators to make comparisons faster and
easier, but if you've done any sort of scripting or programming,
they should be fairly straightforward."