SQL•SQL References

MySQL LOWER() Function

Example

SELECT LOWER("SQL Tutorial is FUN!");

Definition and Usage

The LOWER() function converts a string to lower-case.

Note

The LCASE() function is equal to the LOWER() function.

Syntax

LOWER(
text
)

Parameter	Description
text	Required. The string to convert

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT LOWER("SQL Tutorial is FUN!");

The LOWER() function converts a string to lower-case.

Note

The LCASE() function is equal to the LOWER() function.

Syntax

LOWER(
text
)

Parameter	Description
text	Required. The string to convert

Works in:	From MySQL 4.0