regex101: sql inj

Explanation

Pro

\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*from\s*.+)

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

selectthe literal text select (case insensitive)

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

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

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

fromthe literal text from (case insensitive)

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

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

2nd Alternative(insert\s*.+\s*into\s*.+)

Group 6(insert\s*.+\s*into\s*.+)

insertthe literal text insert (case insensitive)

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

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

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

intothe literal text into (case insensitive)

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

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

3rd Alternative(update\s*.+\s*set\s*.+)

Group 7(update\s*.+\s*set\s*.+)

updatethe literal text update (case insensitive)

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

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

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

setthe literal text set (case insensitive)

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

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

4th Alternative(delete\s*.+\s*from\s*.+)

Group 8(delete\s*.+\s*from\s*.+)

deletethe literal text delete (case insensitive)

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

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

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

fromthe literal text from (case insensitive)

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

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

5th Alternative(drop\s*.+)

Group 9(drop\s*.+)

dropthe literal text drop (case insensitive)

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

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

6th Alternative(truncate\s*.+)

Group 10(truncate\s*.+)

truncatethe literal text truncate (case insensitive)

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

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

7th Alternative(alter\s*.+)

Group 11(alter\s*.+)

alterthe literal text alter (case insensitive)

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

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

8th Alternative(exec\s*.+)

Group 12(exec\s*.+)

execthe literal text exec (case insensitive)

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

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

9th Alternative(\s*(all|any|not|and|between|in|like|or|some|contains|containsall|containskey)\s*.+[\=\>\<=\!\~]+.+)

Group 13(\s*(all|any|not|and|between|in|like|or|some|contains|containsall|containskey)\s*.+[\=\>\<=\!\~]+.+)

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

Group 14(all|any|not|and|between|in|like|or|some|contains|containsall|containskey)

1st Alternativeall

allthe literal text all (case insensitive)

2nd Alternativeany

3rd Alternativenot

4th Alternativeand

5th Alternativebetween

6th Alternativein

7th Alternativelike

8th Alternativeor

9th Alternativesome

10th Alternativecontains

11th Alternativecontainsall

12th Alternativecontainskey

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

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

Character Class[\=\>\<=\!\~]+

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

10th Alternative(let\s+.+[\=]\s*.*)

11th Alternative(begin\s*.*\s*end)

12th Alternative(\s*[\/\*]+\s*.*\s*[\*\/]+)

13th Alternative(\s*(\-\-)\s*.*\s+)

14th Alternative(\s*(contains|containsall|containskey)\s+.*)

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

Global pattern flags

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

Quick Reference

26 tokens

Regular Expression

(\s*([\0\b\'\"\n\r\t\%\_\\]*\s*(((select\s*.+\s*from\s*.+)|(insert\s*.+\s*into\s*.+)|(update\s*.+\s*set\s*.+)|(delete\s*.+\s*from\s*.+)|(drop\s*.+)|(truncate\s*.+)|(alter\s*.+)|(exec\s*.+)|(\s*(all|any|not|and|between|in|like|or|some|contains|containsall|containskey)\s*.+[\=\>\<=\!\~]+.+)|(let\s+.+[\=]\s*.*)|(begin\s*.*\s*end)|(\s*[\/\*]+\s*.*\s*[\*\/]+)|(\s*(\-\-)\s*.*\s+)|(\s*(contains|containsall|containskey)\s+.*)))(\s*[\;]\s*)*)+)

Unit Tests

There are no unit tests.