REGEXP_EXTRACT

DuckDB

regexp_extract(string, regex, name_list, options)

• string: VARCHAR
• regex: VARCHAR
• name_list: VARCHAR[]
• options: VARCHAR

Example

SELECT regexp_extract('John Doe', '([a-z]+) ([a-z]+)', ['first_name', 'last_name'], 'i');