SQL · Reading data

like / ilike

Pattern matching with % and _. LIKE is case-sensitive in PostgreSQL; ILIKE is not.

sqlRunnable example sql course

Syntax

where title like '%sql%'

Example

Open in the lab

WITH lessons(title) AS (VALUES ('SQL basics'), ('CSS grid'))
SELECT title FROM lessons WHERE title LIKE '%SQL%';

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.