Converts a string value to lowercase characters.
- expression: a character expression of one of these types, or an expression that resolves to one of these types:
- LONG VARCHAR
The same data_types as expression.
- LCASE and LOWER are both supported, perform the same function, and can be used interchangeably.
SELECT firstName, LOWER(firstName) AS firstNameLower FROM MYSQL.inventory.cust; VALUES LOWER('John Smith'); -- Returns john smith