regexp operator

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

Returns true if str matches regex. This function is a synonym for rlike operator.

Syntax

str [NOT] regexp regex

Arguments

• str: A STRING expression in UTF8_BINARY collation to be matched.
• regex: A STRING expression with a matching pattern.

Returns

A BOOLEAN.

The regex string must be a Java regular expression. When using literals, use raw-literal (r prefix) to avoid escape character pre-processing.

str NOT regexp ... is equivalent to NOT(str regexp ...).

Examples

SQL

> SELECT r'%SystemDrive%\Users\John' rlike r'%SystemDrive%\\Users.*';
true

> SELECT r'%SystemDrive%\Users\John' rlike r'%SystemDrive%\Users.*';
Error: INVALID_PARAMETER_VALUE.PATTERN

> SELECT r'%SystemDrive%\Users\John' rlike '%SystemDrive%\\\\Users.*';
true

Related functions

• ilike operator
• like operator
• regexp_extract_all function
• regexp_replace function
• split function
• rlike operator