Regular Expressions 101

insertthe literal text insert (case insensitive)

Character Class[\s]+

+matches at least one character from the set below:

\sany whitespace character

intothe literal text into (case insensitive)

Character Class[\s]+

+matches at least one character from the set below:

\sany whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

Group columns(?<columns>.*?)

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

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Character Class[\s]+

+matches at least one character from the set below:

\sany whitespace character

valuesthe literal text values (case insensitive)

Character Class[\s]+

+matches at least one character from the set below:

\sany whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Group values(?<values>.*?)

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

Character Class[\s]*

*matches any number of characters from the set below:

\sany whitespace character

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

insert[\s]+into[\s]+\([\s]*(?<columns>.*?)[\s]*\)[\s]+values[\s]+\((?<values>.*?)[\s]*\);

New

insert    into    (   a,   b,   c   ) values (    " insert into values (1,2,3)",1,2.3,"a,b"     );

insert into (ee,bb,cc) values (aa,234,"asj",2.3);