Regular Expressions 101

Community Patterns

1...45678...877

non-sargable finder

0

Regular Expression
PCRE2 (PHP >=7.3)

/
(ON|JOIN|WHERE|OR|AND)(\s*?.*)(?<func_name>[a-zA-Z]*?\((?<params>[\w\s\.]+)\))
/
gm

Description

find non-sargable sql

Submitted by nick preston - a year ago