REGEXP_CONTAINS

​

Syntax

​

Regexp contains form (scalar)

regexp_contains(value,pattern)

​

Arguments

​

Returns

• Type: BOOLEAN
• Possible values: TRUE when a match is found, otherwise FALSE.
• NULL behavior: Returns NULL if value or pattern is NULL.

​

Properties

​

Usage notes

• Use anchors in the pattern when the whole input must match. The shared engine supports lookaround and backreferences.
• Write value RLIKE pattern to test for a match, or value NOT RLIKE pattern to test for no match.
• Character classes \w, \d, and \s match ASCII characters.

​

Examples

​

Alias calling form: REGEXP_CONTAINS

SELECT regexp_contains('abc123', '[0-9]+') AS matched, regexp_contains('abc', '[0-9]+') AS unmatched;

​

Require a whole-string match

SELECT regexp_contains('123', '^[0-9]+$') AS only_digits, regexp_contains('a123', '^[0-9]+$') AS mixed_text;

​

Limitations

• Invalid patterns or unsupported engine features raise an execution error.
• This form takes two STRING arguments. To set supported regular-expression options, include flags in the pattern. Separate flags and start-position arguments are not available in this form.
• REGEXP_LIKE and REGEXP_CONTAINS take two arguments; RLIKE takes two operands. None of these forms accepts a separate flags argument. For example, use the pattern ’(?i)^a’ for a case-insensitive match at the start of the text.