When matching email domains we assumed that they’re all in lowercase:
SELECT email FROM users WHERE email LIKE '%@boogle.%'
Indeed, domains are often stored inside database in lowercase. It’s not the case for other values, like user names or book genres.
LIKE operator is case sensitive. It means that it matches exactly the same letters as we provide: boogle and not Boogle or BOOGLE.
To match strings in case insensitive manner we can use
ILIKE operator. Here’s an example query that selects all books that have the word “the” in the...