The LOWER function in MSSQL is used to convert a string into lower case. It's similar to UPPER function which converts the string to upper case.
Syntax
LOWER(string)
select lower('This is demo');
------------------------ this is demo
select lower(name) from emp;
------------------------- smith john scott thomas
In MySQL the same functionality can be obtained by using LOWER or LCASE function. The LCASE function in MySQL is a synonym for LOWER function.
LOWER(string) LCASE(string)
mysql> select lower('This is Demo');
+-----------------------+
| lower('This is Demo') |
+-----------------------+
| this is demo |
+-----------------------+
1 row in set (0.00 sec)
mysql> select lcase('This is Demo');
+-----------------------+
| lcase('This is Demo') |
+-----------------------+
| this is demo |
+-----------------------+
1 row in set (0.00 sec)
Back to Converting Functions from MSSQL to MySQL
