Regular Expressions 101

Explanation

Pro

*the literal (32₁₀ / 40₈ / 20₁₆) , repeated any number of times

Group 1(create +table *.+\()

createthe literal text create (case insensitive)

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

tablethe literal text table (case insensitive)

*the literal (32₁₀ / 40₈ / 20₁₆) , repeated any number of times

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

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

Group 2(.+)

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

Global pattern flags

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

Detailed match information will be displayed here automatically.

25 tokens

 *(create +table *.+\()(.+)

New

CREATE TABLE  `3crealivres_new`.`tmp_1`(`rt` INT( 1 ) NOT NULL) ENGINE = MYISAM ;

CREATE TABLE  `3crealivres_new`.`tmp_1`(`rt` INT( 1 ) NOT NULL) ENGINE = MYISAM ;