regexp operator

Returns true if str matches regex.

Since: Databricks Runtime 10.0

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

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

regexp is a synonym for rlike operator.

Examples

> SELECT '%SystemDrive%\\Users\\John' regexp '%SystemDrive%\\\\Users.*';
true