Categories:

String & binary functions (Case Conversion)

LOWER

Returns the input string with all characters converted to lowercase.

Syntax

LOWER( <expr> )
Copy

Arguments

expr

The string expression.

Returns

This function returns a value of type VARCHAR.

Examples

Convert strings in several different languages and character sets to lowercase:

SELECT v, LOWER(v) FROM lu;
Copy
+----------------------------------+----------------------------------+ | v | lower(v) | +----------------------------------+----------------------------------+ | | | | The Quick Gray Fox | the quick gray fox | | LAUGHING ALL THE WAY | laughing all the way | | OVER the River 2 Times | over the river 2 times | | UuVvWwXxYyZz | uuvvwwxxyyzz | | ÁáÄäÉéÍíÓóÔôÚúÝý | ááääééííóóôôúúýý | | ÄäÖößÜü | ääöößüü | | ÉéÀàÈèÙùÂâÊêÎîÔôÛûËëÏïÜüŸÿÇ猜Ææ | ééààèèùùââêêîîôôûûëëïïüüÿÿç眜ææ | | ĄąĆćĘꣳŃńÓ󌜏źŻż | ąąććęęłłńńóóśśźźżż | | ČčĎďĹ弾ŇňŔ੹ŤťŽž | ččďďĺĺľľňňŕŕššťťžž | | АаБбВвГгДдЕеЁёЖжЗзИиЙй | ааббввггддееёёжжззиийй | | КкЛлМмНнОоПпРрСсТтУуФф | ккллммннооппррссттууфф | | ХхЦцЧчШшЩщЪъЫыЬьЭэЮюЯя | ххццччшшщщъъыыььээююяя | | [NULL] | [NULL] | +----------------------------------+----------------------------------+

LOWER supports collation specifications. This LOWER example specifies collation with the tr (Turkish) locale:

SELECT LOWER('I' COLLATE 'tr');
Copy
+-------------------------+ | LOWER('I' COLLATE 'TR') | |-------------------------| | ı | +-------------------------+
Language: English