LCASE() or LOWER() Functions in MySQL
1. LCASE() :
The LCASE() function used to convert a text to lower-case. This function is a similar to the LOWER() function.
Syntax :
SELECT LCASE(text)
Example :
SELECT LCASE("Reading on w3wiki is FUN") AS LowerText;
Output –
LowerText |
---|
reading on w3wiki is fun |
2. LOWER() :
Syntax :
SELECT LOWER(text)
Example :
SELECT LOWER("Studying on w3wiki is FUN") AS LowerText;
Output –
LowerText |
---|
studying on w3wiki is fun |
Contact Us