SQL LIKE matcher
Match values against a simple LIKE pattern with percent, underscore and an explicit escape character.
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Instructions and example
Prefix the chosen escape character. A dangling escape is an error; the escape must occupy 1 UTF-16 code unit.
A_% matches AB and A12. A lacks the character required by underscore, and BA also does not match.
Matching is case-sensitive over UTF-16 code units. Database collations, locales and character classes are not emulated.
Frequently asked questions
How do I match literal % or _ characters?
Prefix the chosen escape character. A dangling escape is an error; the escape must occupy 1 UTF-16 code unit.
Are database case-folding collations reproduced?
Matching is case-sensitive over UTF-16 code units. Database collations, locales and character classes are not emulated.
Calculation criteria and reference materials
- PostgreSQL — SQL Lexical Structure
Matching is case-sensitive over UTF-16 code units. Database collations, locales and character classes are not emulated.
Verification of calculation criteria: · Calculation·verification principles · Report errors