LOWER

Returns the string str with all characters changed to lowercase.

Syntax

LOWER(str);

Arguments

Arguments	Description
str	The string to be lowercase

Return Type

A string data type value.

Examples

SELECT LOWER('Hello, World!')
+------------------------+
| lower('Hello, World!') |
+------------------------+
| hello, world!          |
+------------------------+