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.

Result

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

Verification of calculation criteria: · Calculation·verification principles · Report errors