Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Queries

Like I

LIKE can be a useful operator when you want to compare similar values.

The movies table contains two films with similar titles, 'Se7en' and 'Seven'.

How could we select all movies that start with 'Se' and end with 'en' and have exactly one character in the middle?

SELECT * FROM movies WHERE name LIKE 'Se_en';

1. LIKE is a special operator used with the WHERE clause to search for a specific pattern in a column.

2. name LIKE 'Se_en' is a condition evaluating the name column for a specific pattern.

3. Se_en represents a pattern with a wildcard character. The _ means you can substitute any individual character here without breaking the pattern. The names Seven and Se7en both match this pattern.

Report a Bug
If you see a bug or any other issue with this page, please report it here.