LIKE Wildcard Escape
Medium About 15 min Katabench Pro
Escape LIKE wildcards so a search term cannot match everything.
The full brief is part of Katabench Pro
Pro opens this kata's brief, its starter code and its grader. To see how the track works first, try Block Private Hosts (SSRF), which is free.
How it is graded
Functional tests and adversarial payloads both have to pass before the solution is accepted.
What it practices
- SQL injection
- Keep untrusted input out of SQL grammar with parameters, quoting and allowlisted identifiers.
Related katas
- Sort Column Allowlist Medium Pro Build an ORDER BY clause from a user-chosen column without opening a SQL injection hole.
- Quote SQL Identifier Medium Pro Quote a dynamic SQL identifier so an embedded quote cannot break out of it.
- Block Private Hosts (SSRF) Medium Free Reject internal hosts so a user-supplied URL cannot make the server call itself or its neighbors.
- Comment Renderer (HTML Injection) Easy Free Fix a stored-XSS hole in a comment renderer without breaking its output.