MySQL 8.1
LCASE(str)Parameters
- strVARCHAR
- Source string
Return value
A string in lowercase
Examples
A string in lowercase
MySQL 8.1
SELECT LCASE('SQL Academy') AS lower_case;Case-insensitive search
MySQL 8.1
SELECT member_name
FROM FamilyMembers
WHERE LCASE(member_name) LIKE '%forrest%';