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

Article Tags :

SQL

Recommended Articles

1. LCase() and UCase () Function in MS Access

2. LCASE Function, LEFT Function and LOCATE Function in MariaDB

3. MySQL | Common MySQL Queries

4. MySQL | DATABASE() and CURRENT_USER() Functions

5. MySQL | Ranking Functions

6. Mathematical functions in MySQL

7. MINUTE(), MICROSECOND() and HOUR() functions in MySQL

8. Various String, Numeric, and Date & Time functions in MySQL

9. PLSQL | LOWER Function

10. LPAD, LOWER and LTRIM Function in MariaDB

11. LOWER() function in SQL Server

12. MySQL | LEAD() and LAG() Function

13. PHP | MySQL UPDATE Query

14. PHP | MySQL Database Introduction

15. PHP | MySQL ( Creating Database )

16. PHP | MySQL ( Creating Table )

17. PHP | Inserting into MySQL database

18. PHP | MySQL Select Query

19. PHP | MySQL Delete Query

20. PHP | MySQL ORDER BY Clause

21. PHP | MySQL WHERE Clause

22. MySQL | CREATE USER Statement

23. MySQL | Change User Password

24. PHP | MySQL LIMIT Clause

25. MySQL | DROP USER