`LOWER`String Functions

Converts a string to lowercase.

Syntax

LOWER(str)

Enter values below to update the example in real time.

email→

users→

SELECT LOWER(email) AS email
FROM users
WHERE LOWER(email) LIKE '%@gmail.com';