MySQL LCASE() Function

Example

Convert the text to lower-case:

SELECT LCASE("SQL Tutorial is FUN!");

Definition and Usage

The LCASE() function converts a string to lower - case.

Note:

Syntax

Lcase(

Parameter Values

Parameter

Description text

Technical Details

Works in:

More Examples

Example

Convert the text in "CustomerName" to lower - case:

SELECT LCASE(CustomerName) AS LowercaseCustomerName

FROM Customers;

Previous

Next