Regular Expressions 101

SELECTthe literal text SELECT (case sensitive)

\sany whitespace character

Group 1(.+)

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

\sany whitespace character

FROMthe literal text FROM (case sensitive)

\sany whitespace character

Group 2(((?!\sWHERE).)+)

Group 3((?!\sWHERE).)+

+repeats the group contents below at least once:

Negative Lookahead(?!\sWHERE)

\sany whitespace character

WHEREthe literal text WHERE (case sensitive)

.any character (except for line terminators)

Group 4(\sWHERE\s(.+))?

?repeats the group contents below at most once:

\sany whitespace character

WHEREthe literal text WHERE (case sensitive)

\sany whitespace character

Group 5(.+)

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

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

SELECT\s(.+)\sFROM\s(((?!\sWHERE).)+)(\sWHERE\s(.+))?

New

SELECT 1 FROM table_name AS b WHERE id=3

FROM $2 WHERE $5 GET $1