Skip to main content
SQL โ€ข LESSON 48

LIKE

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

Beginnerโฑ 3 Minutesโญ 610 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