Skip
Arish's avatar

49. Practice - Complex LIKE

Exercise: Contains Pattern

Find students whose courses contain 'y'.

Solution

sql
1SELECT * FROM students
2WHERE course LIKE '%y%';

Returns: Python, Ruby, etc.