SQL LIKE Pattern Tester

Test a LIKE pattern (% = any sequence, _ = any single character) against sample strings. Runs entirely in your browser.

How to use:

  1. Enter a LIKE pattern with % (any sequence) and _ (single char) wildcards
  2. Optionally toggle case-sensitivity
  3. Add your test strings (one per line)
  4. See instant match results as you type

LIKE case-sensitivity varies by database — PostgreSQL's LIKE is case-sensitive by default (use ILIKE for insensitive), MySQL usually isn't.

Results

Alice JohnsonNo match
alice.j@example.comNo match
Bob SmithMatch
Bobby TablesMatch
Carol_AnnNo match
2024-03-11No match
Order #10234No match

Equivalent regex: ^Bob.*$

SQL Formatter

Beautify messy SQL into clean, readable queries instantly.

CSV to SQL

Turn pasted CSV data into ready-to-run INSERT statements.

JSON ↔ SQL

Convert JSON arrays to SQL and SQL results back to JSON.

JOIN Visualizer

See how INNER, LEFT, RIGHT, FULL & CROSS joins differ.