<div>
Found the obvious I didn't see before.
</div>


<div>
<div class="content wysiwyg-content">
What would be the proper way to edit a MySQL data table, replacing a value? &nbsp;<br />
<br />
I'm trying to, for instance, replace value &quot;x&quot; under 'post_type' with value &quot;y&quot; without possibly editing other columns. &nbsp;<br />
<br />
If that isn't possible (editing restricted to column) I would still like to know what the appropriate command is to run the REPLACE syntax on the entire table.
</div>
</div>


What would be the proper way to edit a MySQL data table, replacing a value?  

I'm trying to, for instance, replace value "x" under 'post_type' with value "y" without possibly editing other columns.  

If that isn't possible (editing restricted to column) I would still like to know what the appropriate command is to run the REPLACE syntax on the entire table.

Mass editing MySQL database

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.

MySQL Server

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.