LOWER()

Function Description

LOWER() is used to convert the given string to lowercase.

Function Syntax

> LOWER(str)

Parameter definition

Parameters	Description
str	Required parameters, alphabetical characters.

Example

mysql> select lower('HELLO');
+-------------------+
| lower(HELLO) |
+-------------------+
| hello |
+-------------------+
1 row in set (0.02 sec)

mysql> select lower('A'), lower('B'), lower('C');
+------------------------------------+
| lower(A) | lower(B) | lower(C) |
+------------------------------------+
| a | b | c |
+------------------------------------+
1 row in set (0.03 sec)