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.
| Condition | Description |
|---|---|
| = | 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.
