REGEXP_COUNT

The function evaluates strings using characters as defined by the input character set. It returns an integer indicating the number of occurrences of pattern. If no match is found, then the function returns 0.

Syntax

REGEXP_COUNT(string, pattern)

Example

SELECT REGEXP_COUNT('3454565452545', '45') REGEXP_COUNT

Retunrs:4