LIKE

Source data — Pattern 2: Filtering Data

All queries run against the shared employees table (see schema.sql). This pattern also needs the manager_id column for topic 14 — not required back in Pattern 1. It also needs one row with salary < 50000 for topic 9, which Pattern 1's 6 rows didn't have — add:

INSERT INTO employees (employee_id, first_name, last_name, salary, department_id,
manager_id)
VALUES (7, 'Zoya', 'Khan', 42000, 500, 1);

---

What it does

LIKE does pattern matching on text using two wildcards: % (zero or more characters) and _ (exactly one character). 'A%' means "starts with A"; '%a' would mean "ends with a".

Problem

Find employees whose names start with 'A'.

SELECT *
FROM employees
WHERE first_name LIKE 'A%';

Result