Loading…
Loading…
Test a LIKE pattern (% = any sequence, _ = any single character) against sample strings. Runs entirely in your browser.
LIKE case-sensitivity varies by database — PostgreSQL's LIKE is case-sensitive by default (use ILIKE for insensitive), MySQL usually isn't.
Equivalent regex: ^Bob.*$
SQL LIKE Pattern Tester is a free online tool for testing LIKE wildcard patterns against sample strings. Enter a pattern using % (any sequence of characters) and _ (exactly one character), add test values, and instantly see which strings match — no database connection needed.
Yes. The LIKE Pattern Tester is completely free with no signup and no usage limits, like all SqlInt mini tools.
% matches any sequence, _ matches exactly one character, and backslash escapes (\%, \_) match literals.
Your choice via toggle — but note real collations differ: PostgreSQL LIKE is case-sensitive by default while MySQL usually is not.
No. Every mini tool processes data locally in your browser — pasted text and uploaded files never leave your device.
Catch anti-patterns, implicit joins, and style issues in your SQL.
Open toolBeautify SQL live with instant preview across 7 dialects.
Open toolTurn CSV into CREATE TABLE + INSERTs with auto-detected types.
Open toolConvert JSON arrays to SQL — and INSERTs back to JSON — live.
Open tool