MySQL LCASE Function

MySQL LCASE Function 1

MySQL LCASE is a synonym of the LOWER function. This is useful to convert the given string into lowercase. In this article, we show you how to use this string LCASE in MySQL with an example. The basic syntax of the LCASE Function is as shown below: SELECT LCASE(Expression) FROM [Source] MySQL LCASE Example The LCASE Function … Read more

MySQL LOWER Function

MySQL LOWER Function Example 2

The MySQL LOWER function is one of the String Functions, which is useful to convert the specified character expression to lowercase. The syntax of the LOWER Function in MySQL is as shown below: SELECT LOWER (Expression) FROM [Source] To demonstrate this string Lowercase function in MySQL, we are going to use the customer details table data … Read more