rlike
operator
Applies to: Databricks SQL Databricks Runtime 10.0
Returns true if str
matches regex
.
Arguments
str
: ASTRING
expression to be matched.regex
: ASTRING
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 ...)
.