REGEXP_COUNT
Returns the number of times a regular expression pattern occurs in a string.
Analyze Syntax
func.regexp_count(<str>, <pattern>)
Analyze Examples
func.regexp_count('banana', 'an')
┌───┐
│ 2 │
└───┘
SQL Syntax
REGEXP_COUNT(<str>, <pattern>)
SQL Examples
SELECT REGEXP_COUNT('banana', 'an');
┌───┐
│ 2 │
└───┘