Solved

how do i Update all rows from lowercase to uppercase

Posted on 2004-03-20
2
5,383 Views
Last Modified: 2012-06-21
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
Comment
Question by:weinrj
2 Comments
 
LVL 6

Accepted Solution

by:
vanekl earned 50 total points
ID: 10641479
update yourtable set sname = UPPER(sname);
0
 

Author Comment

by:weinrj
ID: 10641515
Thanks!  I looked at google and found nothing, little did i expect it was that easy *blushes*
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now