opteryx icon indicating copy to clipboard operation
opteryx copied to clipboard

✨ Rewrite RLIKE operations to LIKE and INSTR where possible

Open joocer opened this issue 8 months ago • 0 comments

Regex Pattern Optimized Form
^abc$ col = 'abc'
^abc col LIKE 'abc%'
abc$ col LIKE '%abc'
.*abc.* col LIKE '%abc%'
abc (no .*) col INSTR 'abc'
a.c col LIKE 'a_c'

joocer avatar Mar 05 '25 16:03 joocer