MySQL LOWER Function

The MySQL LOWER function is one of the String methods, which is useful to convert the specified character expression to lowercase and the syntax of it is as shown below:

SELECT LOWER (Expression)
FROM [Source]

To demonstrate this MySQL string lower or lowercase function, we are going to use the customer details table data that we showed below.

Source Table 1

MySQL LOWER Function Example

The Lower converts the user given expression into lowercase characters. The following select query shows multiple ways to use this lower function.

SELECT LOWER('TUTORIAL GATEWAY');

SELECT LOWER('HeLLo GATEwAY');

-- Let me try NULL value
SELECT LOWER(NULL);
lowercase Example 2

In this method example, we are going to implement the string Lowercase on a different set of columns in a table. The below MySQL statement converts the string data in the First_Name, Last_Name, and Education column characters to Lowercase and returns the same as the output.

USE company;
SELECT  First_Name, 
		LOWER(First_Name) AS Lower_FName,
		Last_Name,
        LOWER(Last_Name) AS Lower_LName,
        Education, 
        LOWER(Education) AS Lower_Edu,
        Profession, 
        Yearly_Income,     
        Sales
FROM dupcustomerdetails;
MySQL LOWER Function Example 3