Is there a MySQL command to convert a string to lowercase?

Yes, you can use the LOWER() or LCASE() from MySQL to convert a string to lowercase. Both methods can be used to convert the string into lowercase.

Here is the syntax of LOWER() −

lower(‘yourStringValue);

Or you can use LCASE().

The syntax is as follows −

lcase(‘yourStringValue);

Let us see an example of LOWER(). The query is as follows −

mysql> select lower('JOhN');

Here is the output −

+---------------+
| lower('JOhN') |
+---------------+
| john          |
+---------------+
1 row in set (0.00 sec)

Let us see an example of LCASE(). The query is as follows −

mysql> select lcase('JOhN');

The following is the output −

+---------------+
| lcase('JOhN') |
+---------------+
| john          |
+---------------+
1 row in set (0.00 sec)

Arjun Thakur

Published on 21-Dec-2018 12:47:31

• Related Questions & Answers
• Java program to convert a string to lowercase and uppercase.
• Write a C program to convert uppercase to lowercase letters without using string convert function
• Convert string to lowercase or uppercase in Arduino
• For Hosts Locale how to convert a string to lowercase letters in JavaScript?
• Is there a way to list all the reserved words in MySQL using the MySQL command-line utility?
• How to convert all the records in a MySQL table from uppercase to lowercase?
• Is there any method to convert a Set to immutable in Java
• How to convert lowercase letters in string to uppercase in Python?
• Is there a way to convert Integer field into Varchar without losing data in MySQL?
• How to convert a string to date in MySQL?
• Is there any whoami function or command in MySQL like UNIX?
• Convert text to lowercase with CSS
• How to convert all uppercase letters in string to lowercase in Python?
• MySQL query to convert a string into a month (Number)?
• How to check whether a string is in lowercase or uppercase in R?