Skip to main content
Version: Latest-4.1

lower

Converts all strings in an argument to lower-case.

Syntax​

INT lower(VARCHAR str)

Examples​

MySQL > SELECT lower("AbC123");
+-----------------+
| lower('AbC123') |
+-----------------+
| abc123          |
+-----------------+

keyword​

LOWER

Rocky the happy otterStarRocks Assistant

AI generated answers are based on docs and other sources. Please test answers in non-production environments.