MySQL LOWER() Function

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

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

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

LOWER() Syntax

Here is the syntax of MySQL LOWER() function:

LOWER(str)

Parameters

str

Required. The string to be processed.

Return value

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

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

LOWER() Examples

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

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