SQL ManualSQL FunctionsString FunctionslowerOn this pagelowerlowerβDescriptionβSyntaxβVARCHAR lower (VARCHAR str)Convert all strings in parameters to lowercase. Another alias for this function is lcase.exampleβmysql> SELECT lower("AbC123");+-----------------+| lower('AbC123') |+-----------------+| abc123 |+-----------------+keywordsβLOWER