Home›Learn›SQL›LIKE Operator
SQL Master CourseBeginner Friendly

LIKE Operator

Learn how to search for patterns in text values.

📘 Chapter 14 / 51⏱️ 8–10 Min Read🎯 Beginner Friendly
Course Progress27%

Course Progress

27%

14 / 51 chapters

📖

Theory

Understand the concept step by step

The LIKE operator is used to search for a specified pattern in a column. The % wildcard represents zero or more characters. The _ wildcard represents a single character. LIKE is commonly used with text columns.
💻

Example

See how the concept works in SQL

SQL
SELECT *
FROM users
WHERE name LIKE 'A%';
📤

Output

Understand what the query produces

The query returns names beginning with A.

📝

Practice

Test your understanding

Find all products whose names start with the letter S.

❓

MCQs

Check your SQL knowledge

What is the main concept covered in LIKE Operator?

A.Pattern matching
B.Numeric addition
C.Sorting rows
D.Creating indexes
💼

Interview Questions

Prepare for SQL interviews

1

Interview Question

What is LIKE used for?

2

Interview Question

What does % represent?

3

Interview Question

What does _ represent?