LOWER

Converts all letters of a string to lowercase.

MySQL 8.4

LOWER(str)

str: Source string
VARCHAR

Return value

A string in lowercase

Examples

String in lowercase

MySQL 8.4

SELECT LOWER('Hello World');

LOWER('Hello World')
hello world

Names in lowercase

MySQL 8.4

SELECT member_name,
	LOWER(member_name) AS lower_name
FROM FamilyMembers;

member_name	lower_name
Headley Quincey	headley quincey
Flavia Quincey	flavia quincey
Andie Quincey	andie quincey
Lela Quincey	lela quincey
Annie Quincey	annie quincey
Ernest Forrest	ernest forrest
Constance Forrest	constance forrest
Wednesday Addams	wednesday addams

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).

Where to learn

Function usage

LOWER

Return value

Examples

String in lowercase

Names in lowercase

Details

See also

Where to learn