Syntax of conditions that can appear in a WHERE or HAVING clause.
Contents
| Name | Description |
|---|---|
| bool-condition | Returns True if any of the bool-terms are True |
| bool-factor | A single boolean factor preceeded with an optional NOT |
| bool-primary-between | Returns True if a value is between two given values |
| bool-primary-comparison | Returns the result of a comparison operation |
| bool-primary-exists | Returns True if the result set is not empty |
| bool-primary-in | Determines whether a given value matches any value in a query or a list |
| bool-primary-isnull | Determines whether or not a given expression is NULL |
| bool-primary-like | Returns True if a value matches a given pattern |
| bool-primary-like-regex | Returns True if a value matches a regular expression |
| bool-primary-unique | Returns True if all rows in the result set are unique (distinct) |
| bool-term | Returns True if all of the bool-factors are True |