Database interview questions

How to change column data in Lower Case or in Upper Case in mysql ?
Ans :
Change column data in Lower Case :

UPDATE membersdetails SET CCity = LOWER(CCity) ;


Change column data in Lower Case :

UPDATE membersdetails SET CCity = UPPER(CCity) ;