Why doesn't OR work in re python?

Question

Python

I have a set of SQL queries. I want to extract the WHERE clause from them.

Wrote a small script. I will give an example with one of the requests.

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

import re

pattern = re.compile(r'WHERE[.\s\t]*(GROUP BY|;)')
text = pattern.findall(s)
print(text)

Returns empty quotes.
Please help me formulate the pattern.

Answer 1

re.compile(r'WHERE(.+?)(GROUP BY|;)', re.S)
But for more precision, it's better to add '\b' tokens to limit words, otherwise WHERE might catch as part of another word as well.

Answer 2

You're looking for the following:
WHERE followed by 0 or more dots, whitespace (including tabs) or tabs followed by either GROUP BY or ;
What exactly are you trying to extract from the string?

Answer 3

Train here https://regex101.com/

Answer 4

Hold on . So?