Returns true if
str: A STRING expression to be matched.
regex: A STRING expression with a matching pattern.
regex string must be a Java regular expression.
String literals are unescaped. For example, to match
'\abc', a regular expression for
regex can be
rlike is a synonym for regexp operator.
str NOT rlike ... is equivalent to
NOT(str rlike ...).