MySQL LCASE Function

MySQL LCASE is a synonym of the LOWER function and it 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 and the basic syntax of it 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. Please refer to LOWER method.

SELECT LCASE('HELLO worLD');

SELECT LCASE('MySQL');

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