Pattern Matching with LIKE

The LIKE operator searches for patterns in text.

Wildcards

Examples

-- Names starting with 'A'
SELECT * FROM customers WHERE name LIKE 'A%';
-- Names ending with 'son'
SELECT * FROM customers WHERE name LIKE '%son';
-- Names containing 'ar'
SELECT * FROM customers WHERE name LIKE '%ar%';
-- Exactly 4 characters
SELECT * FROM products WHERE code LIKE '____';

Your Task

Find all products whose name contains the word 'Pro'.