Skip to content

LOWER ​

Converts all characters of expr to lowercase.

Syntax ​

sql
LOWER(expr)

Arguments ​

expr: The value to be processed is of the STRING data type.

Return Values ​

The return value is of the STRING data type.

Example ​

sql
SELECT LOWER('LOREM Ipsum Dolor Sit Amet, ConseteTur');
+-------------------------------------------------+
| LOWER('LOREM IPSUM DOLOR SIT AMET, CONSETETUR') |
+-------------------------------------------------+
|          lorem ipsum dolor sit amet, consetetur |
+-------------------------------------------------+