←TrainerTask 22 / 217

Ticket #22

Search that ignores case

Task

The site search must not depend on letter case: one person types Air, another types air — both should find the same thing.

Find the products whose name contains air, however it was typed. Output name and category. Row order does not matter.

Hint: Postgres has ILIKE for exactly this.

SQL query

Query results will appear here

Preparing the lesson database…