Skip to main content

RLIKE

Returns 1 if the string expr matches the regular expression specified by the pattern pat, 0 otherwise.

Syntax

<expr> RLIKE <pattern>

Examples

SELECT 'databend' rlike 'd*';
+-------------------------+
| ('databend' rlike 'd*') |
+-------------------------+
| 1 |
+-------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today