←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.
You'll need:LIKE: pattern search(opens in a new tab)
SQL query
Query results will appear here
Preparing the lesson database…