O'Reilly Network: AboutSQL: Where to Use WHEREJan 14, 2001, 16:17 (0 Talkback[s])
(Other stories by John Paul Ashenfelter)
"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."