SQL LIKE Pattern Tester
Test SQL LIKE patterns using % and _ wildcards.
Enter sample text and a pattern to see whether the value matches.
Wildcard Rules
%matches any number of characters_matches exactly one character
Test SQL LIKE patterns using % and _ wildcards.
Enter sample text and a pattern to see whether the value matches.
% matches any number of characters_ matches exactly one character