52. NOT LIKE - Contains Pattern

1-- Courses NOT containing 'y'
2SELECT * FROM students
3WHERE course NOT LIKE '%y%';

1-- Names NOT containing 'ar'
2SELECT * FROM students
3WHERE name NOT LIKE '%ar%';