On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
See the whole table
Select some columns
Filtering rows
Text patterns
14. Use text
To be or NULL to be
A little bit of mathematics
Let's practice


Until now, we only worked with numbers in our WHERE clauses. Is it possible to use letters instead? Of course it is! Just remember to put your text in single quotes like this: 'example'.

If you wanted to know the age of all Smiths in your table, you could use the following code:

FROM user
WHERE name = 'Smith';

Note that the case of the letters matters, i.e. 'Smith' is different than 'SMITH'.


Select all columns of all Ford cars from the table.

Stuck? Here's a hint!


  * FROM car
WHERE brand = 'Ford';