BeginnerCoder
Donate← Databases & SQL
8 / 25
Lesson 8 — LIKE search
LIKE: search by pattern
LIKE matches text against a pattern. % means "any characters (or none)", _ means "exactly one character". In SQLite, LIKE ignores upper/lower case for English letters.
WHERE name LIKE 'py%' -- starts with py
WHERE name LIKE '%book%' -- contains book
Why it matters: simple search boxes ("find products containing 'lamp'") are often a LIKE query underneath.
Want it another way?
Task
Write the WHERE so it finds titles containing the word python anywhere. Expected: 2 rows.
Run your code — when the output matches the task, you will see a green check. Then mark the lesson complete.
Test your knowledge
Test your knowledgeA quick 3-question quiz on this lesson — instant feedback.