Regular Expressions 101

(?i)applies the following effective flags to the remainder of the pattern: gi

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

Group 1(CASE\s+WHEN.*?(?<!['"])END)

CASEthe literal text CASE (case insensitive)

\s+any whitespace character, repeated at least once

WHENthe literal text WHEN (case insensitive)

.*?any character (except for line terminators), repeated any number of times

Negative Lookbehind(?<!['"])

Character Class['"]

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

"the literal " (34₁₀ / 42₈ / 22₁₆)

ENDthe literal text END (case insensitive)

Global pattern flags

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?i)(CASE\s+WHEN.*?(?<!['"])END)

New

iduser + CaSe  WhEn ("end") = 0 THEN 'CASE WHEN' ELSE 'END' END + sum(iduser ) + CASE  WHEN LANGUAGE = 3 THEN 4 ELSE 5 END