LCASE

Change the text to lowercase.

SELECT LCASE(“SQL Tutorial is FUN!”);

Definition and Usage

The LCASE() function transforms a string to lowercase.

Note: The LOWER() function serves as a synonym for the LCASE() function.

LCASE(text)

Parameter	Description
text	Mandatory: The string to be converted.

Works in:

From MySQL 4.0

Transform the text in the “CustomerName” column to lowercase.

SELECT LCASE(CustomerName) AS LowercaseCustomerName
FROM Customers;