Product Solutions Support
Try MemSQL

RLIKE

Performs a partial-string search, with regular expression matching.

str RLIKE regexp
str REGEXP regexp

Arguments

Return Type

Boolean

Info

Regular expressions in MemSQL are not Unicode-aware, and so may fail to match characters that would otherwise be considered equivalent.

Examples

memsql> select 'ohai' rlike 'o';
+------------------+
| 'ohai' rlike 'o' |
+------------------+
|                1 |
+------------------+

memsql> select 'ohai' rlike 'o.+';
+--------------------+
| 'ohai' rlike 'o.+' |
+--------------------+
|                  1 |
+--------------------+

memsql> select 'olé' regexp 'É';
+--------------------+
| 'olé' regexp 'É'   |
+--------------------+
|                  0 |
+--------------------+
Was this article useful?