55. Practice - NOT LIKE Contains

Exercise: Exclude Contains

Find students whose names do NOT contain 'on'.

Solution

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