MySQL LCASE Function

MySQL LCASE Function 1

MySQL LCASE is a synonym of the LOWER function. This LCASE String Function 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 … Read more

MySQL LOWER Function

MySQL LOWER Function Example 2

MySQL LOWER 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 that we … Read more