What is the usage of the lower function in MySQL?

In MySQL, the LOWER() function is used to convert all characters of a string to lowercase. The syntax is as follows:

LOWER(str)

“In this case, the string ‘str’ needs to be converted to lowercase.”

Suppose there is a table called customers, with a column named name. Now, if we want to convert all the values in the name column to lowercase, we can use the following query:

SELECT LOWER(name) FROM customers;

This will return all values in the name column in lowercase form.