LIKE

🎬 Scenario: Finding Shows with “Dark” in the Title#

Your manager at Netflix, Alex, is analyzing user interest in dark-themed content.

Alex asks:

Can you retrieve all shows that have the word “Dark” anywhere in the title?

Your task is to query the netflix_series table and provide the requested data.

1. Filtering Text Data with ‘LIKE’#

The LIKE operator allows us to search for patterns in text. Instead of filtering by an exact match (=), we can use wildcard characters:

Syntax:

SELECT column1, column2  
FROM table_name  
WHERE column_name LIKE 'pattern';

Example Query: Finding Titles Containing “Dark”

SELECT title, genre, rating  
FROM netflix_series  
WHERE title LIKE '%Dark%';

Expected Output:

What’s Happening?

• LIKE %Dark% searches for any title that contains the word “Dark” anywhere.
• The % wildcard allows matches at the beginning, middle, or end of the title.

2. More Pattern Matching Examples#

Example Query: Finding Titles That Start with “S”

SELECT title, genre  
FROM netflix_series  
WHERE title LIKE 'S%';

Expected Output:

What’s Happening?

• LIKE S% ensures that only titles starting with “S” appear in the results.

✍️ SQL Exercises#

Exercise 1: Finding Netflix Shows with “Game” in the Title#

Netflix executives want a list of all series that contain “Game” anywhere in the title.

Filter condition:

• title must contain the word “Game”.

Expected Output Example:

Write an SQL query to return the requested data.

Exercise 2: Finding Shows That Start with “B”#

Alex is preparing a new recommendation system and wants to identify all Netflix series whose titles start with “B”. Order the table in the ascending order of rating.

Filter condition:

• title must start with the letter “B”.

Expected Output Example:

Write an SQL query to return the requested data.