Regular Expressions 101

Pro

Group 1(.*?)

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

Non-Capturing Group(?:\b(and|or|not)\b|$)

1st Alternative\b(and|or|not)\b

\ban ASCII word boundary

Group 2(and|or|not)

1st Alternativeand

andthe literal text and (case sensitive)

2nd Alternativeor

orthe literal text or (case sensitive)

3rd Alternativenot

notthe literal text not (case sensitive)

\ban ASCII word boundary

2nd Alternative$

$end of string, or before its final line terminator

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

(.*?)(?:\b(and|or|not)\b|$)

New

some column name1 = some value1 and some column name2 < another value2 or some column name 3 > value3 not column name 4 = value4 and name5 = value5

some column name1 = some value1 and some column name2 < another value2 or some column name 3 > value3 not column name 4 = value4 and name5 = value5