Collections:
LOWER() - Convert String to Lower Case
How to convert a string to lower case using the LOWER() function?
✍: FYIcenter.com
LOWER(str) is a MySQL built-in function that converts all characters of a given into lower case characters. For example:
SET @str = 'dba.FYIcenter.com'; SELECT LOWER(@str); -- +-------------------+ -- | LOWER(@str) | -- +-------------------+ -- | dba.fyicenter.com | -- +-------------------+
Reference information of the LOWER() function:
LOWER(str): modstr Returns the string str with all characters changed to lowercase according to the current character set mapping, or NULL if str is NULL. The default character set is utf8mb4. Arguments, return value and availability: str: Required. The string to be converted. modstr: Return value. The converted string. Available since MySQL 4.0.
Related MySQL functions:
⇒ LPAD() - Left-Padding String
⇐ LOCATE() - Locate Substring Starting at N
2023-11-12, 219🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...