MySQL LOWER() Functions – String Functions

by · Published · Updated

MySQL LOWER() Functions: Syntax

LOWER ( string );

MySQL LOWER() Functions: Description

LOWER() functions converts all the characters in a string to lowercase characters according to the current character set mapping.

The default character set is utf8mb4.

LOWER() does not work when applied to binary strings (BINARY, VARBINARY, BLOB). To convert lettercase conversion of a binary string, first convert it to a nonbinary string using a character set appropriate for the data stored in the string. See example 1

For collations of Unicode character sets, LOWER() work according to the Unicode Collation Algorithm (UCA) version in the collation name, if there is one, and UCA 4.0.0 if no version is specified. For example, utf8mb4_0900_ai_ci and utf8_unicode_520_ci work according to UCA 9.0.0 and 5.2.0, respectively, whereas utf8_unicode_ci works according to UCA 4.0.0. See Section 10.10.1, “Unicode Character Sets”.

Note : This function is multibyte safe. LCASE() used within views is rewritten as LOWER().

MySQL LOWER() Functions: Parameter

[table caption=”” width=”100%” colwidth=”15%|30%|55%” colalign=”left|left|left”]
Name, Required /Optional, Description
string,Required, The input string which needs to be converted to lowercase characters.
[/table]

MySQL LOWER() Functions: Output

[table caption=”” width=”100%” colwidth=”20%|80%” colalign=”left|left”]
Returns , Lowercase of input string
[/table]

MySQL LOWER() Functions: Available from

[table caption=”” width=”100%” colwidth=”25%|75%” colalign=”left|left”]
Version, MySQL 4.0
[/table]

MySQL LOWER() Functions: Example 1

This will work in mysql version 8.

mysql> SET @str1 = BINARY 'TUTORIAL';
mysql> SELECT LOWER(@str1), LOWER(CONVERT(@str1 USING utf8mb4));
+-------------+------------------------------------+
| LOWER(@str1) | LOWER(CONVERT(@str1 USING utf8mb4)) |
+-------------+------------------------------------+
| TUTORIAL | tutorial |
+-------------+------------------------------------+

This will work in previous versions of mysql :

In below example LOWER function will not work with binary variables :

mysql> SELECT LOWER(BINARY 'TUTORIAL'); 
+------------------------------------+
LOWER(BINARY 'TUTORIAL')
+------------------------------------+
|  8485847982736576 |
+------------------------------------+

In below example LOWER() function will work with binary variables using characterset conversion :

mysql> SELECT LOWER(CONVERT(BINARY 'TUTORIAL' USING utf8mb4));
+-------------------------------------------------------------------+
LOWER(CONVERT(BINARY 'TUTORIAL' USING utf8mb4))
+-------------------------------------------------------------------+
| tutorial |
+--------------------------------------------------------------------+

MySQL LOWER() Functions: Example 2

mysql> SELECT LOWER('TUTORIALMINES.NET') ;
+------------------------------------+
| LOWER('TUTORIALMINES.NET') |
+------------------------------------+
| tutorialmines.net                           |
+------------------------------------+

See all MySQL String functions MySQL 8 String Functions.

Related articles : CONCAT(), CONCAT_WS() , UCASE(), UPPER(), LCASE().

PHP Related articles : STRTOLOWER(), STRTOUPPER(), LCFIRST(), UCFIRST(), UCWORDS(), PHP STRING FUNCTIONS().

You may also like...