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)