Regular Expressions 101

Pro

SELECTthe literal text SELECT (case sensitive)

Group 1(.+)

.+any character (except for line terminators), repeated at least once

\s+any whitespace character, repeated at least once

FROMthe literal text FROM (case sensitive)

\s+any whitespace character, repeated at least once

Group 2(\w+)

\w+any word character, repeated at least once

\s+any whitespace character, repeated at least once

Group 3(WHERE\s+(\w+\s*=\s*\d+))?

?repeats the group contents below at most once:

WHEREthe literal text WHERE (case sensitive)

\s+any whitespace character, repeated at least once

Group 4(\w+\s*=\s*\d+)

\w+any word character, repeated at least once

\s*any whitespace character, repeated any number of times

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

\s*any whitespace character, repeated any number of times

\d+a digit, repeated at least once

\s*any whitespace character, repeated any number of times

Group 5(REGION\s+(\w+))?

?repeats the group contents below at most once:

REGIONthe literal text REGION (case sensitive)

\s+any whitespace character, repeated at least once

Group 6(\w+)

\w+any word character, repeated at least once

Global pattern flags

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

No unit tests · Add a test to get started

25 tokens

SELECT(.+)\s+FROM\s+(\w+)\s+(WHERE\s+(\w+\s*=\s*\d+))?\s*(REGION\s+(\w+))?

There are no unit tests, click to add some.