Regular Expressions 101

Pro

1st Alternative(?!(?:FROM|INTO|NEXTVAL|UPDATE|JOIN)\b)\S*\s*

Negative Lookahead(?!(?:FROM|INTO|NEXTVAL|UPDATE|JOIN)\b)

Non-Capturing Group(?:FROM|INTO|NEXTVAL|UPDATE|JOIN)

1st AlternativeFROM

FROMthe literal text FROM (case insensitive)

2nd AlternativeINTO

INTOthe literal text INTO (case insensitive)

3rd AlternativeNEXTVAL

NEXTVALthe literal text NEXTVAL (case insensitive)

4th AlternativeUPDATE

UPDATEthe literal text UPDATE (case insensitive)

5th AlternativeJOIN

JOINthe literal text JOIN (case insensitive)

\ban ASCII word boundary

\S*any non-whitespace character, repeated any number of times

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

2nd Alternative\b(?:NEXTVAL\W*|\w+\s[\s`'"]*)([\[\]\w\._-]+)

\ban ASCII word boundary

Non-Capturing Group(?:NEXTVAL\W*|\w+\s[\s`'"]*)

1st AlternativeNEXTVAL\W*

NEXTVALthe literal text NEXTVAL (case insensitive)

\W*any non-word character, repeated any number of times

2nd Alternative\w+\s[\s`'"]*

\w+any word character, repeated at least once

\sany whitespace character

Character Class[\s`'"]*

*matches any number of characters from the set below:

\sany whitespace character

`the literal ` (96₁₀ / 140₈ / 60₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 1([\[\]\w\._-]+)

Character Class[\[\]\w\._-]+

+matches at least one character from the set below:

\[the literal [ (91₁₀ / 133₈ / 5B₁₆)

\]the literal ] (93₁₀ / 135₈ / 5D₁₆)

\wany word character

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

-the literal - (45₁₀ / 55₈ / 2D₁₆)

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

No unit tests · Add a test to get started

25 tokens

Regular Expression

(?!(?:FROM|INTO|NEXTVAL|UPDATE|JOIN)\b)\S*\s*|\b(?:NEXTVAL\W*|\w+\s[\s`'"]*)([\[\]\w\._-]+)

Unit Tests

There are no unit tests, click to add some.