ucase & lcase string functionsWe can change a lower case data ( string ) in out mysql table to upper case by using ucase function. Same way we can change upper case characters to lower case by using lcase function. Here is the syntaxSame way we can use lcase string function to change upper case characters to lower case by using lcase function In our newsletter subscribers table we can convert or display all the emails in lower case letters. While subscribing visitors may enter their email address in Upper case letters. We can use lcase to change all email address to lower case characters . Your Rating
|