How many rows match the pattern?
-- names: 'Jn', 'Jane', 'Jonah', 'Jean', 'Jan' SELECT COUNT(*) FROM people WHERE name LIKE 'J_n%';
- 3
- 1
- 4
- 2
_ matches exactly one character and % any run, so Jane, Jonah and Jan match; Jn and Jean do not.-- names: 'Jn', 'Jane', 'Jonah', 'Jean', 'Jan' SELECT COUNT(*) FROM people WHERE name LIKE 'J_n%';
_ matches exactly one character and % any run, so Jane, Jonah and Jan match; Jn and Jean do not.