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 17:17:31