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
: ASTRING
expression to be matched.regex
: ASTRING
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$'
.
Examples
> SELECT regexp_like('%SystemDrive%\\Users\\John', '%SystemDrive%\\\\Users.*');
true