regexp operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.0 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 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

> 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