Lesson 4 of 30
Filtering with text
Today at the studio
Sora wants a pitch for a comedy festival and needs the right shows. Last year, Kou typed "comedy" in lowercase in half the forms. You decide to be exact.
The idea
Text goes between single quotes: 'Comedy'. Compare it with = and <> just like numbers.
In SQLite, text comparison with = is case-sensitive, so 'comedy' and 'Comedy' are different. Quotes are only for text, never for numbers or column names.
Example
SELECT name FROM staff WHERE role = 'Composer'
Your turn
0 of 4 questions
Question 1 of 4
Which shows are comedies? Show title.