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
16. The percentage sign (%) continued
To be or NULL to be
A little bit of mathematics
Let's practice


That's the way to go! Of course, the percentage sign (%) can be put anywhere between the single quotes and as many times as it's necessary:

FROM user
WHERE name LIKE '%A%';

That's right, the example above will select any user whose name contains at least one 'A'.

Remember that the percentage sign (%) can also replace zero characters, so the name can also begin or end with the A.


Select vin of all cars whose model ends with an s.

Stuck? Here's a hint!


FROM car
WHERE model LIKE '%s';