WHERE Conditions

In the examples so far, you have used only the = (equal to) operator. You filtered rows based on their being equal to a specific value. Many other operators and conditions can be used with the WHERE clause; they’re listed in Table 6.2.

Table 6.2. WHERE Clause Search Conditions
ConditionDescription
=Equal to. Tests for equality.
<>Not equal to. Tests for inequality.
<Less than. Tests that the value on the left is less than the value on the right.
<=Less than or equal to. Tests that the value on the left is less than or equal to the value on the right.
>Greater than. Tests that the value on the left is greater than the value on the right.
>=Greater than or equal to. Tests that the value on the left is greater than or equal to the value ...

Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.