Regular Expressions 101

Pro

substrthe literal text substr (case insensitive)

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

\h*any horizontal whitespace character, repeated any number of times

Non-Capturing Group(?:=\h*'[^']*'|IN\h*$[^()]*$)

1st Alternative=\h*'[^']*'

=the literal = (61₁₀ / 75₈ / 3D₁₆)

\h*any horizontal whitespace character, repeated any number of times

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Negated Character Class[^']*

*matches any number of characters outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd AlternativeIN\h*$[^()]*$

INthe literal text IN (case insensitive)

\h*any horizontal whitespace character, repeated any number of times

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Negated Character Class[^()]*

*matches any number of characters outside the set below:

(the literal ( (40₁₀ / 50₈ / 28₁₆)

)the literal ) (41₁₀ / 51₈ / 29₁₆)

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

substr\([^()]*\)\h*(?:=\h*'[^']*'|IN\h*\([^()]*\))

New

SELECT * 
FROM tbl 
WHERE col_a = 'abc' 
AND SUBSTR(col_b, 7, 2) = 'cd' 
AND col_c LIKE 'ACD0%' 
AND SUBSTR(col_d, 10, 1) IN ('A','B','C') 
AND SUBSTR(col_e, 5, 3) = 'cde' 
AND SUBSTR(col_f, 2, 1) IN ('C','D','E')