regexp_like function

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

regexp_like( str, 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. String literals are unescaped. For example, to match '\abc', a regular expression for regex can be '^\\abc$'.

Common error conditions

• INVALID_PARAMETER_VALUE.PATTERN

Examples

> SELECT regexp_like('%SystemDrive%\\Users\\John', '%SystemDrive%\\\\Users.*');
true

> SELECT regexp_like('abc', '[invalid');
  Error: INVALID_PARAMETER_VALUE.PATTERN

Related functions

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