condition

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 (,)