rlike operator

Applies to: Databricks SQL 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 ...).

Common error conditions

• INVALID_PARAMETER_VALUE.PATTERN

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

Related functions

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