>_QueryLocalCSV & JSON tools that run in your browser

How do I search for a text pattern in a column with SQL LIKE?

SELECT * FROM data
WHERE customer LIKE 'A%';

Run this query on the demo dataset →

LIKE matches text against a pattern where % stands for any sequence of characters (including none) and _ stands for exactly one character. customer LIKE 'A%' keeps every row whose customer name starts with the letter A — swap the pattern to '%smith%' to find a substring anywhere in the text instead.

A table named data with columns: order_id (integer), customer (text), country (text), category (text), quantity (integer), unit_price (real), order_date (text, YYYY-MM-DD).

Want to run it on your own file? Open it with Filter a CSV: your file becomes the table data, and you can paste this query with your own column names.

Related recipes