REGEXP_COUNT

​

Syntax

​

Scalar

regexp_count(value, pattern)

​

Arguments

​

Returns

• Type: BIGINT
• Possible values: A nonnegative match count, with zero when there is no match.
• NULL behavior: Returns NULL when value or pattern is NULL.

​

Properties

​

Examples

​

Typical behavior

SELECT regexp_count('a1b2c3', '[0-9]') AS matches, regexp_count('abc', '[0-9]') AS no_match;

​

Count groups of digits

SELECT regexp_count('a12b345', '[0-9]+') AS digit_groups, regexp_count('a12b345', '[0-9]') AS individual_digits;

​

Limitations

• Invalid patterns 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.