Case conversion, lower to upper string functions in MySQL for field data

ucase() & lcase() string functions

SELECT ucase('this is a string')

The output will be THIS IS A STRING

We 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.

Same way we can use lcase string function to change upper case characters to lower case by using lcase function

SELECT lcase('This is a String')

The output is this is a string

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 .

select lcase(email) from subscribe

The above command will display only. We can use update command to change the records. Same way we can change to upper case also.

select ucase(email) from subscribe

SQL String References LEFT side of string Query

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com