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:

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

Example Query: Finding Titles Containing “Dark”

1SELECT title, genre, rating  
2FROM netflix_series  
3WHERE 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”

1SELECT title, genre  
2FROM netflix_series  
3WHERE 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.