ReferenceSQL 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