Regex like
Returns true when the left string matches the regular expression on the right.
Category: comparison
SQL symbol: RLIKE
Syntax
sql
<haystack> RLIKE <regex>Parameters
<haystack>— The value tested against the expression. Acceptsnvarchar,varbinary,varchar.<regex>— The regular expression to match. Unlike LIKE, it matches anywhere in the value unless anchored with^and$. Acceptsnvarchar,varbinary,varchar.
Returns
Examples
sql
SELECT name FROM $planets WHERE name RLIKE '^M.*s$';Mars
Signatures
nvarchar RLIKE nvarchar→ booleannvarchar RLIKE varbinary→ booleannvarchar RLIKE varchar→ booleanvarbinary RLIKE nvarchar→ booleanvarbinary RLIKE varbinary→ booleanvarbinary RLIKE varchar→ booleanvarchar RLIKE nvarchar→ booleanvarchar RLIKE varbinary→ booleanvarchar RLIKE varchar→ boolean
Notes
A regular expression is more expressive than a LIKE pattern and more expensive to run; prefer LIKE when a prefix or suffix match is all that is needed.