EasyWHERE & Filtering
Find customers whose email contains "gmail"
The query
SQL
SELECT name, email, city
FROM customers
WHERE email ILIKE '%gmail%';Note
“Leading wildcard % prevents index usage. Use pg_trgm extension for efficient text search.
SELECT name, email, city
FROM customers
WHERE email ILIKE '%gmail%';Note
“Leading wildcard % prevents index usage. Use pg_trgm extension for efficient text search.