how do i Update all rows from lowercase to uppercase

Hi,

I had previouslly made a db with two columns, uid, and sname.  sname is currently all lowercase, but i need them now all uppercase. is there a way in mysql console to do this massive update easily?  

i *rather* not use a php strtoupper in the echo, but i guess i can make a loop that does the update for me?
weinrjAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
vaneklConnect With a Mentor Commented:
update yourtable set sname = UPPER(sname);
0
 
weinrjAuthor Commented:
Thanks!  I looked at google and found nothing, little did i expect it was that easy *blushes*
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.