regexp_count( str, regexp )
An INTEGER.
The regexp
string must be a Java regular expression.
String literals are unescaped. For example, to match '\abc'
, a regular expression for regexp
can be '^\\abc$'
.
In case of a malformed regexp
the function returns an INVALID_PARAMETER_VALUE error.
If either argument is NULL
the result is NULL
.
Examples
> SELECT regexp_count('Steven Jones and Stephen Smith are the best players', 'Ste(v|ph)en');
> SELECT regexp_count('Mary had a little lamb', 'Ste(v|ph)en');
> SELECT regexp_count(NULL, 'Ste(v|ph)en');
> SELECT regexp_instr('Mary had a little lamb', NULL);