Open the context
Choose the project folder and name the files or behavior involved.
Workflows
Coding workflows · Literal SQL LIKE patterns
03
A concrete starting point
Escape an SQL LIKE literal using an exclamation mark as the escape character. Test percent, underscore, exclamation marks and empty text with a bound parameter, rejecting NUL without adding wildcards or claiming case-sensitive matching.
Define the change
Describe the input, expected output and boundaries that must stay intact.
Inspect the work
Review the proposed edits and any commands before relying on their result.
Check the outcome
Compare actual behavior with the expected result. If a check fails, investigate it before applying more changes.
Literal SQL LIKE patterns
A concrete starting point
def like_literal(text):
if type(text) is not str or "\x00" in text:
raise ValueError("like.text")
return text.replace("!", "!!").replace("%", "!%").replace("_", "!_")
SQL = "SELECT value FROM items WHERE value LIKE ? ESCAPE '!'"The example is a starting point for a real project, not a claim that generated code is already tested. Adjust paths, dependencies and expected behavior to match your application.