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)