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
SELECT LCASE('HELLO worLD');
-- Let me try NULL value
SELECT LCASE('TUTORIAL GATEWAY'), LCASE(NULL);
Please refer to LOWER function.