48. Practice - More LIKE Patterns

Exercise: Ending Pattern

Find students whose names end with 'n'.

Solution

1SELECT * FROM students
2WHERE name LIKE '%n';

Single Character Wildcard

The underscore _ matches exactly one character:

1-- Names with 4 characters
2SELECT * FROM students
3WHERE name LIKE '____';