regexp_count

Count the number of matches of a regex pattern in a given string.

Usage details

Input
table

col

col
random 123 text 456 test

LQL Command

select *, regexp_count(col, '\\d+') as ct from table

Output

col	ct

col	ct
random 123 text 456 test	2