O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required