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; |