

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
- 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?
- How to convert lowercase letters in string to uppercase in Python?
- Is there any method to convert a Set to immutable in Java
- 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?
Advertisements