Normalizing email case for lookups

Question

Accepted Answer

LOWER converts every character in the string to lowercase. UPPER does the opposite. These are commonly used to normalize data before comparison, for example: WHERE LOWER(email) = 'alice@example.com' for case-insensitive email lookups.