regexp
operator
Applies to: Databricks SQL
Databricks Runtime 10.0 and above
Returns true if str
matches 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.