Not regex like
Returns true when the left string does not match the regular expression on the right.
Category: comparison
SQL symbol: NOT RLIKE
Syntax
sql
<haystack> NOT RLIKE <regex>Parameters
<haystack>— The value tested against the expression. Acceptsnvarchar,varbinary,varchar.<regex>— The regular expression that must not match. It matches anywhere in the value unless anchored. Acceptsnvarchar,varbinary,varchar.
Returns
Examples
sql
SELECT name FROM $planets WHERE name NOT RLIKE '^M' LIMIT 3;Venus
Earth
Jupiter
Signatures
nvarchar NOT RLIKE nvarchar→ booleannvarchar NOT RLIKE varbinary→ booleannvarchar NOT RLIKE varchar→ booleanvarbinary NOT RLIKE nvarchar→ booleanvarbinary NOT RLIKE varbinary→ booleanvarbinary NOT RLIKE varchar→ booleanvarchar NOT RLIKE nvarchar→ booleanvarchar NOT RLIKE varbinary→ booleanvarchar NOT RLIKE varchar→ boolean