LCASE

PostgreSQL equivalent:

A synonym for LOWER: converts all letters of a string to lowercase.

MySQL 8.4

LCASE(str)

Return value

A string in lowercase

MySQL 8.4

SELECT LCASE('SQL Academy') AS lower_case;

lower_case
sql academy

MySQL 8.4

SELECT member_name
FROM FamilyMembers
WHERE LCASE(member_name) LIKE '%forrest%';

member_name
Ernest Forrest
Constance Forrest