Find part of a name with LIKE
LIKE tests text against a pattern. % matches any sequence, including an empty one, and _ matches one character. Put % on both sides to find a word anywhere in a name.
SELECT name FROM products WHERE name LIKE '%Pen%';Common misunderstanding
LIKE is not a numeric comparison. Test price ranges with comparison operators such as >= and <=.
Related missions
Practice opens in this page’s language. Change it in the practice options at any time.