<div>
update tbl<br />
set columnname = 'TAXC-00000002'<br />
where columnname = 'TAXC-00000001'
</div>


update tbl
set columnname = 'TAXC-00000002'
where columnname = 'TAXC-00000001'

<div>
Thank you for your fast respond to this issue, it worked just perfect&gt;
</div>


Thank you for your fast respond to this issue, it worked just perfect>

<div>
<div class="content wysiwyg-content">
I need the command to update a column in my DB 5000 rows.<br />
Taxcode column reads TAXC-00000001, I need to change all of them to TAXC-00000002<br />
another words it will read non-tax items. I like to voided changing one by one.<br />
<br />
thank you
</div>
</div>


I need the command to update a column in my DB 5000 rows.
Taxcode column reads TAXC-00000001, I need to change all of them to TAXC-00000002
another words it will read non-tax items. I like to voided changing one by one.

thank you

Mass update MySQL

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.