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, 210🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...