Blog · Guide
SQL LIKE Explained: Pattern Matching with % and _
LIKE lets you match text patterns — starts with, ends with, contains — using % and _ wildcards.
The two wildcards
%= any number of characters (including none)_= exactly one character
SELECT name FROM products WHERE name LIKE 'Ch%';
That finds names starting with “Ch” (Cheese, Chips…).
Contains a word
LIKE '%tea%' matches anywhere in the string. Useful for search-box style filters — just know it can be slower on huge tables.
Try it yourself
The fastest way to lock this in is a short drill on the same Northstar Market tables.