Excluding End Patterns
sql
1-- Courses NOT ending with 't'
2SELECT * FROM students
3WHERE course NOT LIKE '%t';Excludes: JavaScript (ends with 't')
More Examples
sql
1-- Names NOT ending with 'a'
2SELECT * FROM students
3WHERE name NOT LIKE '%a';
1-- Courses NOT ending with 't'
2SELECT * FROM students
3WHERE course NOT LIKE '%t';Excludes: JavaScript (ends with 't')
1-- Names NOT ending with 'a'
2SELECT * FROM students
3WHERE name NOT LIKE '%a';