• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5428
  • Last Modified:

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?
0
weinrj
Asked:
weinrj
1 Solution
 
vaneklCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now