Skip to content
Related Articles

Related Articles

Improve Article
LCASE() or LOWER() Functions in MySQL
  • Last Updated : 03 Sep, 2020

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
My Personal Notes arrow_drop_up
Recommended Articles
Page :