REGEXP_EXTRACT

Syntax

REGEXP_EXTRACT( string, pattern )

Description

Returns the substring string that matches the regular expression pattern pattern.

Argument types:

  • stringString
  • patternString

Return type: String

Note

Only constant values are accepted for the arguments (pattern).

Note

See the documentation of the data source to clarify the regular expression syntax.

Data source support

ClickHouse 19.13, MySQL 8.0.12, PostgreSQL 9.3.