My like query isn't returning expected results. how do i search for patterns correctly?

Example:

-- Incorrect usage of LIKE operator
SELECT * FROM products WHERE name LIKE 'toy%car';
Solution:

-- Correct usage of LIKE operator
SELECT * FROM products WHERE name LIKE 'toy% %car';
The '%' in a LIKE query represents any number of characters. To search for words 'toy' and 'car' separated by a space or other characters, use '% %'.

Beginner's Guide to SQL