Jump to: navigation, search

Mysql LCASE

From w3cyberlearnings

Contents

MySQL LCASE Function

This function returns all lowercase for a given string. It is equal to LCASE() function.

Syntax LCASE

  • Str: A string input to convert to lowercase.
LCASE(Str);

Example 1

mysql> SELECT LCASE('SHE is Good');
+----------------------+
| LCASE('SHE is Good') |
+----------------------+
| she is good          |
+----------------------+
1 row in set (0.00 sec)


Related Links


Navigation
Web
SQL
MISC
References