SQL Operators and Pattern Matching Functions ​

Yellowbrick supports a subset of the POSIX-style regular expressions (regex).

Within a Yellowbrick query, a pattern may be used in the following different ways:

• Preceded by one of the regex operators: ~, ~*, !~, !~*
• In a LIKE condition
• In a SIMILAR TO condition
• In a SUBSTRING function
• In one of the supported regular expression functions: REGEXP_REPLACE, REGEXP_INSTR, REGEXP_EXTRACT, REGEXP_LIKE

The following sections cover all of these constructs.