ucase & lcase string functions

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. Here is the syntax

select ucase('this is a string')

The output will be THIS IS A STRING
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

Your Rating

String Functions
substring_index to get part of a string from a delimiter
substring Part of string from a position
concat: adding a substring to all data present in a field
character_length: Number of chars in a string
locate: searching for a matching string inside field data
character_length: length of string present in a field for each record
ucase:lower to upper and upper to lower case conversion functions
left: left part of the string data in a field
replace: replace part of a sting with sub string in a field
length: string length function
reverse: string reverse function
repeat: string repeat number of times
RIGHT: Right part of the string
lpad: string padding from left
like: String pattern matching against record

SQL Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns