我的书签
添加书签
移除书签Comparison Operators
These operations test whether two expressions are equal. Comparison Operators result in a value of true, false or null. The following tables show the usual comparison operators that can be used for all simple data types:
| Operator | Description |
|---|---|
| < | less than |
| > | greater than |
| <= | less than or equal to |
| >= | greater than or equal to |
| = | equal |
| <> | not equal |
| != | not equal - same as <> |
If used in the WHERE Clause the following operators are valid in addition.
| Operator | Description |
|---|---|
| LIKE | matches a part of the given value |
| NOT | negates a condition |
| IS NULL | matches a NULL value |
| IS NOT NULL | matches a Non-NULL value |
| ~ | regular expression match |
| !~ | negated regular expression match |
| between | a BETWEEN x and y: shortcut for a >= x AND a <= y |
