Replacing strings in a specific table within phpMyAdmin

Submitted by johnvsc on March 22, 2009 - 7:57pm
in
  1. In the phpMyAdmin interface for your site, navigate to the correct table
  2. Click the SQL tab, and in the SQL query box...
  3. Using this code and replacing the ** with correct information, test to see if you are replacing the correct string 
    SELECT replace(*rowName*,'*original string*','*new string*'), *rowName* FROM `*table name*`
  4. if this checks out, then use this code to replace the string: 
    update *table name* set *rowName*= replace(*rowName*,'*original string*','*new string*');
  5. Check the results
      6. Note: In the code above, the *text inside the asterisks* sometimes have ' on either side of them. replace the sample text above INCLUDING THE ASTERISKS ... being mindful of the single quotes!