regexp_count
[ 1 Usage details ]
Count the number of matches of a regex pattern in a given string.
Usage details
Input
table
col |
---|
random 123 text 456 test |
LQL Command
select *, regexp_count(col, '\\d+') as ct from table
Output
col | ct |
---|---|
random 123 text 456 test | 2 |