LCASE() FUNCTION in MySQL

LCASE() FUNCTION
The MySQL LCASE function is used to convert all characters in the specified string to lowercase. The various versions of MySQL support the LCASE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.

Syntax:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
LCASE( string )
LCASE( string )
LCASE( string )

Parameters:
string: It is used to specify the string to modify.

Example:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
mysql> SELECT LCASE ( 'HELLO WORLD 123' );
mysql> SELECT LCASE ( 'HELLO WORLD 123' );
mysql> SELECT LCASE ( 'HELLO WORLD 123' );

Output:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
‘hello world 123
‘hello world 123’
‘hello world 123’

Explanation:
All the letters are converted to lowercase.