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 GEEKSFORGEEKS is FUN") AS LowerText;
Output –
LowerText |
reading on geeksforgeeks is fun |
2. LOWER() :
Syntax :
SELECT LOWER(text)
Example :
SELECT LOWER("Studying on GeeksForGeeks is FUN") AS LowerText;
Output –
LowerText |
studying on geeksforgeeks is fun |
Last Updated :
03 Sep, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...