Suggest an editImprove this articleRefine the answer for “What does LIKE do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`LIKE` is a filtering operator that searches strings by pattern in SQL queries, used inside `WHERE` to find values *similar* to a given template; it works with two special characters, `%` (any number of characters) and `_` (exactly one character). **Key point:** for example, `WHERE name LIKE 'A%'` finds rows where the name starts with "A", and `WHERE city LIKE '%burg'` finds rows where the city's name ends in "burg".Shown above the full answer for quick recall.Answer (EN)Image`LIKE` is a filtering operator that searches strings by pattern in SQL queries. It's used inside `WHERE`, to find values *similar* to a given template. It works with two special characters: - `%`, replaces any number of characters (including zero); - `_`, replaces exactly one character. Examples: - `WHERE name LIKE 'A%'`, finds every row where the name starts with "A". - `WHERE city LIKE '%burg'`, finds rows where the city's name ends in "burg". - `WHERE code LIKE '12__'`, finds every four-digit code that starts with "12".For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.