Text & patterns Scalar

regexp_extract_all()

Finds non-overlapping occurrences of the regex in the string and returns the corresponding values of the capturing group. A set of optional regex options can be set.

Arguments & returns

5 overloads

`regexp_extract_all(string, regex)`

Scalar

Overload link	`string`	`regex`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR[]`

`regexp_extract_all(string, regex, group)`

Scalar

Overload link	`string`	`regex`	`group`	Returns
#02	`VARCHAR`	`VARCHAR`	`INTEGER`	`VARCHAR[]`
#03	`VARCHAR`	`VARCHAR`	`VARCHAR[]`	`VARCHAR[]`

`regexp_extract_all(string, regex, group, options)`

Scalar

Overload link	`string`	`regex`	`group`	`options`	Returns
#04	`VARCHAR`	`VARCHAR`	`INTEGER`	`VARCHAR`	`VARCHAR[]`
#05	`VARCHAR`	`VARCHAR`	`VARCHAR[]`	`VARCHAR`	`VARCHAR[]`

Example

SELECT regexp_extract_all('Peter: 33, Paul:14', '(\w+):\s*(\d+)', 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

BigQuery`regexp_extract_all()`

Same function

Snowflake`regexp_substr_all()`

REGEXP_SUBSTR_ALL(subject, pattern)

In DuckDB

REGEXP_EXTRACT_ALL(subject, pattern)

SQLGlot example ↗

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3

Arguments & returns

regexp_extract_all(string, regex)

regexp_extract_all(string, regex, group)

regexp_extract_all(string, regex, group, options)

Example

In other engines

BigQueryregexp_extract_all()

Snowflakeregexp_substr_all()

`regexp_extract_all(string, regex)`

`regexp_extract_all(string, regex, group)`

`regexp_extract_all(string, regex, group, options)`

BigQuery`regexp_extract_all()`

Snowflake`regexp_substr_all()`