MySQL LCASE Function

MySQL LCASE is a synonym of the LOWER function. This LCASE String Function is useful to convert the given string into lowercase. In this article, we show you how to use this string LCASE in MySQL with an example. The basic syntax of the LCASE Function is as shown below:

SELECT LCASE(Expression) FROM [Source]

MySQL LCASE Example

The LCASE Function in MySQL converts the user specified expression into lowercase. The following String Function query shows you multiple ways to use this lcase function.

SELECT LCASE('HELLO worLD');

SELECT LCASE('MySQL');

-- Let me try NULL value
SELECT LCASE('TUTORIAL GATEWAY'), LCASE(NULL);
MySQL LCASE Function 1

Please refer to LOWER function.