Beginner
Case 3 of 50
Case 003: The Almost-Right Name
customers
Support forwards a garbled voicemail, and the manager passes it straight to Alex.
"I could only make out part of the name — something with 'in' in it. Can you pull up everyone that could match?"
The data Alex is looking at
customers
| id | name | |
|---|---|---|
| 1 | Nina | nina@example.com |
| 2 | Nino | nino@example.com |
| 3 | Tina | tina@example.com |
| 4 | David | david@example.com |
| 5 | Maya | maya@shopmail.com |
TASK
Help Alex answer the manager:
“Find every customer whose name contains "in" anywhere in it.”
Write a query above and hit Run to see what comes back.
No hints requested yet — click "Get a hint" when you're stuck.
Alex's final query — this is for reference. Copy it into your own thinking, not into the editor above.
SELECT *
FROM customers
WHERE name LIKE '%in%';
What that query returns
Case Debrief
LIKE, wildcard pattern matching
- % matches any run of characters, including zero — that's why '%in%' matches Nina, Nino, and Tina, no matter what surrounds the "in".
- _ matches exactly one character — for example, 'Nin_' would match both Nina and Nino (one character after "Nin"), but not Tina.