LCASE()

Function Description

LCASE() is used to convert the given string to lowercase, synonyms for LOWER().

Function Syntax

> LCASE(str)

Parameter definition

Parameters	Description
str	Required parameters, alphabetical characters.

Example

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

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