bugl
bugl
HomeLearnPatternsPathsSearchPremium
HomeLearnPatternsPaths

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

MySQL LCASE() Function

Example

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

Definition and Usage

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

Note

The LOWER() function is a synonym for the LCASE() function.

Syntax

LCASE(
text
)

Parameter Values

ParameterDescription
textRequired. The string to convert

Technical Details

Works in:From MySQL 4.0

Previous

MySQL INSTR() Function

Next

MySQL LEFT() Function