<div>
Thanks! &nbsp;I looked at google and found nothing, little did i expect it was that easy *blushes*
</div>


Thanks!  I looked at google and found nothing, little did i expect it was that easy *blushes*

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I had previouslly made a db with two columns, uid, and sname. &nbsp;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? &nbsp;<br />
<br />
i *rather* not use a php strtoupper in the echo, but i guess i can make a loop that does the update for me?
</div>
</div>


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?

how do i Update all rows from lowercase to uppercase

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.