Names containing a word (LIKE)

What you are given

Use WHERE name LIKE ‘%University%’. The % wildcard matches any run of characters.

Starting point

SELECT name
FROM universities
WHERE name LIKE '%University%'
ORDER BY name;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.

Did you know

LIKE with % is pattern matching; use it for “contains”, “starts with” (‘abc%’) and “ends with” (‘%abc’). (SQLite docs)

More Education challenges

• Universities in the capital Easy
• A short list (IN) Easy
• How many universities? Easy
• Cities with more than one university (HAVING) Medium
• The top university city (CTE) Medium

Open it in the playground →