LOWER
Converts all letters of a string to lowercase.
MySQL 8.1
LOWER(str)Parameters
- strVARCHAR
- Source string
Return value
A string in lowercase
Examples
String in lowercase
MySQL 8.1
SELECT LOWER('Hello World');Names in lowercase
MySQL 8.1
SELECT member_name,
LOWER(member_name) AS lower_name
FROM FamilyMembers;Details
Works with Cyrillic too. The synonym is LCASE. The function does not change binary strings (the BINARY type, the result of CHAR without USING): convert them to text first with CONVERT(value USING utf8mb4).