regexp_extract_all()

Splits the string along the regex and extract all occurrences of group. A set of optional options can be set.

Arguments & returns

3 overloads

Scalar

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

Scalar

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

Scalar

Overload link	`string`	`regex[`	`group = 0][`	`options]`	Returns
#03	`VARCHAR`	`VARCHAR`	`INTEGER`	`VARCHAR`	`VARCHAR[]`

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.

SELECT
  regexp_extract_all('hello_world', '([a-z ]+)_?', 1);

REGEXP_SUBSTR_ALL(subject, pattern)

In DuckDB

REGEXP_EXTRACT_ALL(subject, pattern)