Important - Do Not make any changes to your MySQL Database unless:

1. You are confident you understand what you are doing
2. You make a database backup first

This article will evolve over time as new tips are added to it.

Code For a Search and Replace in MySQL
Here is how to perform a search and replace in phpMyAdmin

update table_name set field_name='NewName' where field_name='OldName'