LOWER()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a string converted to lowercase.
USAGE
LOWER(string)
Argument Name | Description |
|---|---|
| The string to transform |
DETAILS
LOWER() is a string function that returns the string argument with any uppercase characters transformed into lowercase based on the character set mapping in effect.
The default character set mapping is utf8mb4.
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT LOWER('MariaDB');
+------------------+
| LOWER('MariaDB') |
+------------------+
| mariadb |
+------------------+
Not Supported with Binary Stings
SET @a = BINARY 'MARIADB';
SELECT LOWER(@a), LOWER(CONVERT(@a USING utf8mb4));
+-----------+----------------------------------+
| LOWER(@a) | LOWER(CONVERT(@a USING utf8mb4)) |
+-----------+----------------------------------+
| MARIADB | mariadb |
+-----------+----------------------------------+