Skip to main content
Skip to main content

LOWER

lower

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