regexp operator

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