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 |
+-------------------------------------------------+