Open In App

LCASE() or LOWER() Functions in MySQL

Improve
Improve
Like Article
Like
Save
Share
Report

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
Previous
Next
Share your thoughts in the comments
Similar Reads