EasyWHERE & Filtering

Find products whose name starts with "Pro"

The query

SQL

SELECT product_id, name, price
FROM products
WHERE name ILIKE 'Pro%'; -- ILIKE = case-insensitive LIKE

Tested against PostgreSQL 16

Note

“LIKE uses % (any chars) and _ (single char). ILIKE is case-insensitive (PostgreSQL specific).