MySQL LCASE() Function

In MySQL, the The LCASE() function converts the specified string to lowercase and returns it.

The LCASE() function is the same as LOWER() function.

If you want to convert a string to uppercase, use the UCASE() or UPPER() function.

LCASE() Syntax

Here is the syntax of MySQL LCASE() function:

LCASE(str)

Parameters

str

Required. The string to be processed.

Return value

The LCASE(str) function returns the lowercase form of the specified string.

The function will NULL return when the str parameter is NULL.

LCASE() Examples

SELECT LCASE('Hello'), LCASE(NULL);

+----------------+--------------------------+
| LCASE('Hello') | LCASE(NULL)              |
+----------------+--------------------------+
| hello          | NULL                     |
+----------------+--------------------------+