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