Change the text to lowercase.
| SELECT LOWER(“SQL Tutorial is FUN!”); |
The LOWER() function converts a string to lowercase.
It’s worth noting that the LCASE() function is synonymous with the LOWER() function.
| LOWER(text) |
|
Parameter |
Description |
|
text |
Input required: The string to be converted to lowercase. |
| Works in: | From MySQL 4.0 |
Transform the text in the “CustomerName” column to lowercase.
| SELECT LOWER(CustomerName) AS LowercaseCustomerName FROM Customers; |