regex101: JavaScript Match Workspace

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

+repeats the group contents below at least once:

Character Class[\0\b\'\"\n\r\t\%\_\\]*

*matches any number of characters from the set below:

\0the literal (0₈ / 0₁₀ / 0₁₆)

\ba backspace character (ASCII 8)

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

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

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

\ra carriage return (ASCII 13)

\ta tab character (ASCII 9)

\%the literal % (37₁₀ / 45₈ / 25₁₆)

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

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

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

1st Alternative(select\s+\S.*\s+from\s+\S+)

Group 5(select\s+\S.*\s+from\s+\S+)

selectthe literal text select (case insensitive)

\s+any whitespace character, repeated at least once

\Sany non-whitespace character

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

\s+any whitespace character, repeated at least once

fromthe literal text from (case insensitive)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

2nd Alternative(insert\s+into\s+\S+)

Group 6(insert\s+into\s+\S+)

insertthe literal text insert (case insensitive)

\s+any whitespace character, repeated at least once

intothe literal text into (case insensitive)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

3rd Alternative(update\s+\S+\s+set\s+\S+)

Group 7(update\s+\S+\s+set\s+\S+)

updatethe literal text update (case insensitive)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

\s+any whitespace character, repeated at least once

setthe literal text set (case insensitive)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

4th Alternative(delete\s+from\s+\S+)

Group 8(delete\s+from\s+\S+)

deletethe literal text delete (case insensitive)

\s+any whitespace character, repeated at least once

fromthe literal text from (case insensitive)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

Group 10((drop)|(create)|(alter)|(backup))

1st Alternative(drop)

Group 11(drop)

dropthe literal text drop (case insensitive)

2nd Alternative(create)

Group 12(create)

createthe literal text create (case insensitive)

3rd Alternative(alter)

Group 13(alter)

alterthe literal text alter (case insensitive)

4th Alternative(backup)

Group 14(backup)

backupthe literal text backup (case insensitive)

\s+any whitespace character, repeated at least once

1st Alternative(table)

2nd Alternative(index)

3rd Alternative(function)

4th Alternative(PROCEDURE)

5th Alternative(ROUTINE)

6th Alternative(SCHEMA)

7th Alternative(TRIGGER)

8th Alternative(USER)

9th Alternative(VIEW)

\s+any whitespace character, repeated at least once

\S+any non-whitespace character, repeated at least once

6th Alternative(truncate\s+table\s+\S+)

7th Alternative(exec\s+)

8th Alternative(\/\*)

9th Alternative(--)

Group 29(\s*[\;]\s*)*

Global pattern flags

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

Search reference

Regular Expression

(\s*([\0\b\'\"\n\r\t\%\_\\]*\s*(((select\s+\S.*\s+from\s+\S+)|(insert\s+into\s+\S+)|(update\s+\S+\s+set\s+\S+)|(delete\s+from\s+\S+)|(((drop)|(create)|(alter)|(backup))\s+((table)|(index)|(function)|(PROCEDURE)|(ROUTINE)|(SCHEMA)|(TRIGGER)|(USER)|(VIEW))\s+\S+)|(truncate\s+table\s+\S+)|(exec\s+)|(\/\*)|(--)))(\s*[\;]\s*)*)+)

New

exect