rlike operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.0

Returns true if str matches regex.

Syntax

str [NOT] rlike 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.

rlike is a synonym for regexp operator.

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

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