NOT LIKE

How can we exclude rows matching a text pattern?

Beginner⏱ 3 Minutes⭐ 630 XP

🤔 THE QUESTION

How can we exclude rows matching a text pattern?

💡 WHAT IS IT?

The NOT LIKE operator filters out all records whose string values match the specified pattern.

🎯 WHAT IS IT USED FOR?

Omitting test email accounts, excluding legacy prefix IDs, cleaning raw text datasets.

💻 EXAMPLE

SELECT name
FROM employees
WHERE name NOT LIKE 'A%';

Practice typing production-grade SQL code for NOT LIKE.