condition¶
Syntax¶
Description¶
Syntax | Description |
|---|---|
condition | Judgment condition. |
> | Relational operator: > |
>= | Relational operator: >= |
< | Relational operator: < |
<= | Relational operator: <= |
= | Relational operator: = |
<> | Relational operator: <> |
is | Relational operator: is |
is not | Relational operator: is not |
const_null | Constant value: null |
like | Relational operator: used for wildcard matching. |
pattern_string | Pattern matching string, which supports wildcard matching. In WHERE LIKE, SQL wildcard characters "%" and "_" are supported. "%" represents one or more characters. "_" represents only one character. |
attr_expr | Attribute expression. |
attrs_value_set_expr | Collection of attribute values. |
in | Keyword used to determine whether attributes are in the same collection. |
const_string | String constant. |
const_int | Integer constant. |
( | Start of the specified constant collection. |
) | End of the specified constant collection. |
, | Separator comma (,) |