LCASE(str): LCASE() is a synonym for LOWER() : LCASE « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. LCASE
mysql>
mysql> SELECT LCASE('ABC');
+--------------+
| LCASE('ABC') |
+--------------+
| abc          |
+--------------+
1 row in set (0.00 sec)

mysql>








23.18.LCASE
23.18.1.LCASE(str): LCASE() is a synonym for LOWER()
23.18.2.Use LCASE to convert first name to lower case