See the whole table
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice
Instruction
Nice! Now, sometimes we may not remember just one letter of a specific name. Imagine we want to find a girl whose name is... Catherine? Katherine?
SELECT * FROM user WHERE name LIKE '_atherine';
The underscore sign (_) matches exactly one character. Whether it's Catherine or Katherine – the expression will return a row.
Exercise
Select all columns for cars which brand matches 'Volk_wagen'.
Stuck? Here's a hint!
Type:
SELECT * FROM car WHERE brand LIKE 'Volk_wagen';
