Regular Expressions 101

.*?any character, repeated any number of times

Group 1(WHERE.*?)

WHEREthe literal text WHERE (case sensitive)

.*?any character, repeated any number of times

Group 2(GROUP BY|;|\n)

1st AlternativeGROUP BY

GROUP BYthe literal text GROUP BY (case sensitive)

2nd Alternative;

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

3rd Alternative\n

\na line-feed (newline) character (ASCII 10)

Global pattern flags

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

s modifier: single line. Allows a dot to match line terminators

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

.*?(WHERE.*?)(GROUP BY|;|\n)

Test String
New

s = '''FROM clinics INNER JOIN clinic_drug on clinics.clinicId = clinic_drug.clinicId
    WHERE clinic_drug.amount = 0 
    GROUP BY clinics.name;'''

s = '''FROM clinics INNER JOIN clinic_drug on clinics.clinicId = clinic_drug.clinicId
    WHERE clinic_drug.amount = 2 
    GROUP BY clinics.name;'''

s = '''FROM clinics INNER JOIN clinic_drug on clinics.clinicId = clinic_drug.clinicId
    WHERE clinic_drug.amount = 3;

Regular Expression

Test StringNew

ExtractionProcessing...

Test String
New

Extraction
Processing...