Flags

Flags, also called modifiers, allow specific rules to be applied to the whole regular expression.

Flags may be passed to the REGEXP_REPLACE, REGEXP_INSTR, REGEXP_EXTRACT, and REGEXP_LIKE functions in the flags value.


Flag	Description
`c`	Sets matching to be case-sensitive
`i`	Sets matching to be case-insensitive

Note: Matching is case-sensitive by default.

Note: If contradicting flags are specified, the Yellowbrick engine uses the last option in the flags parameter.

Examples

premdb=# select REGEXP_REPLACE('Hello World','[hewo]','_','c') from sys.const;
 regexp_replace 
----------------
 H_ll_ W_rld
(1 row)

premdb=# select REGEXP_REPLACE('Hello World','[hewo]','_','i') from sys.const;
 regexp_replace 
----------------
 __ll_ __rld
(1 row)