City of the Dead by John Zavocki

help

Replacing strings in a specific table within phpMyAdmin

In the phpMyAdmin interface for your site, navigate to the correct table
Click the SQL tab, and in the SQL query box...
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*`   
```

if this checks out, then use this code to replace the string:

update *table name* set *rowName*= replace(*rowName*,'*original string*','*new string*');

Check the results

Submitted by johnvsc on 5 April 2011 - 8:03am