Regular Expressions 101

Explanation

Pro

(?i)applies the following effective flags to the remainder of the pattern: i

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

UPDATEthe literal text UPDATE (case insensitive)

Character Class[ \t\n]{1,}

{1,}matches at least one character from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\ta tab character (ASCII 9)

\na line-feed (newline) character (ASCII 10)

Group 1(fact)

factthe literal text fact (case insensitive)

Group 2(.*)

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

\na line-feed (newline) character (ASCII 10)

Group 3(from)?

?repeats the group contents below at most once:

fromthe literal text from (case insensitive)

Group 4([ \t\n]{1,})?

?repeats the group contents below at most once:

Character Class[ \t\n]{1,}

{1,}matches at least one character from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\ta tab character (ASCII 9)

\na line-feed (newline) character (ASCII 10)

Group 5(.*)?

?repeats the group contents below at most once:

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

\n*a line-feed (newline) character (ASCII 10), repeated any number of times

setthe literal text set (case insensitive)

Character Class[ \n\t]{1,}

{1,}matches at least one character from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\na line-feed (newline) character (ASCII 10)

\ta tab character (ASCII 9)

Group 6(coloana)

coloanathe literal text coloana (case insensitive)

Character Class[ \t\n]*

*matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\ta tab character (ASCII 9)

\na line-feed (newline) character (ASCII 10)

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

Character Class[ \t\n]*

*matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

\ta tab character (ASCII 9)

\na line-feed (newline) character (ASCII 10)

Group 7(ifnull\(\s*)*

*repeats the group contents below any number of times:

ifnullthe literal text ifnull (case insensitive)

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

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

Group 8([\w\d]*)

Character Class[\w\d]*

*matches any number of characters from the set below:

\wany word character

\da digit

Group 9([\ ,'\w\n\t)(\n=.]*)

Character Class[\ ,'\w\n\t)(\n=.]*

*matches any number of characters from the set below:

\ the literal (32₁₀ / 40₈ / 20₁₆)

,the literal , (44₁₀ / 54₈ / 2C₁₆)

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

\wany word character

\na line-feed (newline) character (ASCII 10)

\ta tab character (ASCII 9)

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

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

\na line-feed (newline) character (ASCII 10)

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

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

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

(?i)UPDATE[ \t\n]{1,}(fact)(.*)\n(from)?([ \t\n]{1,})?(.*)?\n*set[ \n\t]{1,}(coloana)[ \t\n]*=[ \t\n]*(ifnull\(\s*)*([\w\d]*)([\ ,'\w\n\t)(\n=.]*);

New

update         fact,x2,asdasjsdjbmfeweoewo
from asdas,asaskdvd
set coloana = ifnull(   ifnull(    col2,'Test'), 'Test2')
where c = c.s.
and asdsa = asda.asda;

UPdate fact,x2
set coloana = ifnull(col2,'Test')
where c = c.s.;

update
 fact,x2
from
 asdas
set coloana = ifnull(col2,'Test')
where c = c.s.
and asdsa = asda.asda;

update fact,x2
from asdas
set coloana = (select x from y where x.fg = x2.asfds)
where c = c.s.
and asdsa = asda.asda;

Extraction

update         fact,x2,asdasjsdjbmfeweoewo
from asdas,asaskdvd
set coloana = ifnull(   ifnull(    col2,'Test'), 'Test2')
where c = c.s.
and asdsa = asda.asda;

UPdate fact,x2
set coloana = ifnull(col2,'Test')
where c = c.s.;

update
 fact,x2
from
 asdas
set coloana = ifnull(col2,'Test')
where c = c.s.
and asdsa = asda.asda;

update fact,x2
from asdas
set coloana = (select x from y where x.fg = x2.asfds)
where c = c.s.
and asdsa = asda.asda;