SQL Queries (SELECT, UPDATE, INSERT INTO, and DELETE)

Prev Next

SQL database queries such as SELECT, UPDATE, INSERT INTO, and DELETE are matched to prevent any database changes.

Validator

No Validation

Matched expressions

Regex expressions

Description

Score

\b(?i)(select)\s[\w\*\)\(\,\s]+\s(from)\s\b

Matches a SQL SELECT query pattern.

1

\b(?i)(UPDATE)\s[\w]+\s(SET)\s[\w\,\'\=]+\b

Matches a SQL UPDATE query pattern.

1

\b(?i)INSERT\sINTO\s[\d\w]+[\s\w\d\)\(\,]*\sVALUES\s\([\d\w\'\,\)]+\b

Matches a SQL INSERT INTO query pattern.

1

\b(?i)(DELETE)\s(FROM)\s[\d\w\'\=\#]+\b

Matches a SQL DELETE query pattern.

1



Ignored expressions

None