<div>
UPDATE yourtable set created_by = 522 WHERE created_by = 62
</div>


UPDATE yourtable set created_by = 522 WHERE created_by = 62

<div>
Try:<br />
<br />
UPDATE table_name SET created_by = '522' WHERE created_by = '62'
</div>


Try:

UPDATE table_name SET created_by = '522' WHERE created_by = '62'

<div>
I guess &nbsp;ChrisStanyon beat you all by seconds! &nbsp;:)<br />
<br />
Thanks everyone! &nbsp; The solution worked. &nbsp;<br />
<br />
Rowby
</div>


I guess  ChrisStanyon beat you all by seconds!  :)

Thanks everyone!   The solution worked.  

Rowby

<div>
Or I should say by ONE second! :)
</div>


<div>
<div class="content wysiwyg-content">
Hello &nbsp;I am in phpmyadmin version &nbsp;3.4.11.1<br />
<br />
I have a mysql database that I want to search and replace a row of data under these conditions.<br />
<br />
IT will search the Created By column for exactly the number 62 and replace it with exactly the number 522<br />
<br />
I have backed up my mysql database.<br />
<br />
THanks!<br />
<br />
Rowby<a href="https://filedb.experts-exchange.com/incoming/2013/02_w09/638159/creaated-by.jpg" target="_blank" title="Screen capture (7 KB)"><img alt="Screen capture" class="file-block lazyload" style="max-width: 124px;" data-src="https://filedb.experts-exchange.com/incoming/2013/02_w09/638159/creaated-by.jpg" /></a>
</div>
</div>


creaated-by.jpg

Hello  I am in phpmyadmin version  3.4.11.1

I have a mysql database that I want to search and replace a row of data under these conditions.

IT will search the Created By column for exactly the number 62 and replace it with exactly the number 522

I have backed up my mysql database.

THanks!

Rowby

Mysql command via phpmyadmin to search and replace one row of data.

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.