Skip
Arish's avatar

47. Practice - LIKE Patterns

Exercise: Find Names

Find all students whose names start with 'J'.

Solution

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

Practice

sql
1-- Names ending with 'e'
2SELECT * FROM students WHERE name LIKE '%e';
3
4-- Courses containing 'Script'
5SELECT * FROM students WHERE course LIKE '%Script%';