Enum-type attributes
Enum attributes support specific operators and conditions.
| Operators | Description | Example |
|---|---|---|
= |
Equal-to | customer_account_status = 'DISABLED' |
!= |
Not-equal-to | customer_account_status != 'DISABLED' |
IN |
Allows you to specify multiple values in a WHERE clause |
enum_attribute IN ('value1', 'value2', 'value3') |
Conditions accept UTF-8 characters and must be wrapped with single quotes
', similar to theENUMtype in MySQL.Conditions only accept a value chosen from a list of permitted values.
Conditions are case-sensitive and whitespaces are syntactically significant.
Single quotes within a condition must be escaped (ie.
'\'VIP\'').For Segmentation, we're using multiple clauses with connectors to specify multiple values.