Extract all matches for a given regex pattern from a string.
Usage details
Input
table
col |
|---|
random 123 text 456 test |
LQL Command
select *, regexp_extract_array(col, '[a-z]+') as matches from table
Output
col | matches |
|---|---|
random 123 text 456 test | WrappedArray(random, text, test) |