Skip to main content
SQL • LESSON 48

LIKE

How can we find text values that follow a specific pattern?

Beginner3 Minutes610 XP
🤔 THE QUESTION

How can we find text values that follow a specific pattern?

💡 WHAT IS IT?

The LIKE operator performs pattern-matching searches on string columns using the % and _ wildcards.

🎯 WHAT IS IT USED FOR?

Prefix matching, searching names beginning with specific letters, country code lookups.

💻 EXAMPLE
SELECT name
FROM employees
WHERE name LIKE 'A%';

🎯 Mission Objectives

Practice typing production-grade SQL code for LIKE.

  • LIKE operator
  • Prefix wildcard (%)
  • Pattern matching
  • String filters