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.

Reference: DuckDB 2.0.0

Arguments & returns

5 overloads

regexp_extract_all(string, regex)

Scalar
Overload link stringregex Returns
#01 VARCHARVARCHAR VARCHAR[]

regexp_extract_all(string, regex, group)

Scalar
Overload link stringregexgroup Returns
#02 VARCHARVARCHARINTEGER VARCHAR[]

regexp_extract_all(string, regex, name_list)

Scalar
Overload link stringregexname_list Returns
#03 VARCHARVARCHARVARCHAR[] VARCHAR[]

regexp_extract_all(string, regex, group, options)

Scalar
Overload link stringregexgroupoptions Returns
#04 VARCHARVARCHARINTEGERVARCHAR VARCHAR[]

regexp_extract_all(string, regex, name_list, options)

Scalar
Overload link stringregexname_listoptions Returns
#05 VARCHARVARCHARVARCHAR[]VARCHAR VARCHAR[]

Example

regexp_extract_all example
SQL
Haybarn WASM 2.0.0-rc12 Β· In your browser

Engine example Β· Run to view results.

In other engines

BigQueryregexp_extract_all()

Same function

Snowflakeregexp_substr_all()

REGEXP_SUBSTR_ALL(subject, pattern)
In DuckDB
REGEXP_EXTRACT_ALL(subject, pattern)

SQLGlot example β†—