Securitypopular

SQL Injection Detection Regex Pattern

Detects suspicious SQL injection patterns.

Pattern
('|(\-\-)|(;)|(\|\|)|(\*)|(<)|(>)|(\^)|(\[)|(\])|(\{)|(\})|(%)|(\$)|(\bOR\b)|(\bAND\b))

Tested examples

' OR '1'='1
admin'--
1; DROP TABLE users
normal text
user123

Test it live

Live Regex TesterJS
8 matches
/
/g
' OR '1'='1
admin'--
1; DROP TABLE users
Match 1at index 0
'
$1: '$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 2at index 2
OR
$1: OR$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: OR$16:
Match 3at index 5
'
$1: '$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 4at index 7
'
$1: '$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 5at index 9
'
$1: '$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 6at index 17
'
$1: '$2: $3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 7at index 18
--
$1: --$2: --$3: $4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:
Match 8at index 22
;
$1: ;$2: $3: ;$4: $5: $6: $7: $8: $9: $10: $11: $12: $13: $14: $15: $16:

Use it in your language

Use it in
// JavaScript / Node.js
const regex = /('|(\-\-)|(;)|(\|\|)|(\*)|(<)|(>)|(\^)|(\[)|(\])|(\{)|(\})|(%)|(\$)|(\bOR\b)|(\bAND\b))/;
const value = "' OR '1'='1";
const isMatch = regex.test(value);
console.log(isMatch); // true / false

// Extract all matches
const matches = value.match(/('|(\-\-)|(;)|(\|\|)|(\*)|(<)|(>)|(\^)|(\[)|(\])|(\{)|(\})|(%)|(\$)|(\bOR\b)|(\bAND\b))/g) || [];

Tags

Frequently asked questions

How do I use the SQL Injection Detection regex pattern in JavaScript?
Wrap the pattern in slashes: const re = /('|(\-\-)|(;)|(\|\|)|(\*)|(<)|(>)|(\^)|(\[)|(\])|(\{)|(\})|(%)|(\$)|(\bOR\b)|(\bAND\b))/; — then call re.test(value) to check a single value, or value.match(re) to find matches. The "Use it in" snippets above give you the exact code for 9 languages.
Is this sql injection detection regex production-ready?
Yes — every pattern in the library is tested against valid and invalid examples. Still, regex is one layer in a defense-in-depth strategy: pair it with server-side validation (e.g. Luhn for credit cards, mod-97 for IBAN, real DNS lookup for emails) for critical inputs.
Why does my pattern fail in another language?
Different regex engines (PCRE, Java, Python, Go's RE2) support slightly different syntax. The most common gotchas: lookbehinds (not in RE2), named groups syntax, and how backslashes need to be escaped inside string literals. The code snippets above already escape correctly for each language.
Can I edit this pattern and test it live?
Yes — use the live tester above. Type your test string and toggle flags (g, i, m, s, u, y) to see matches highlighted instantly, including capture groups.

Related patterns

See all Security

Browse the full library — 300 tested regex patterns across 16 categories.