Timeline for What SQL Query to do a simple find and replace
Current License: CC BY-SA 2.5
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 15, 2014 at 5:03 | comment | added | benz001 | Note also that even if you desire to use relative paths, lots of parts of wordpress tend to auto-insert full paths. To really get this working a plugin like: wordpress.org/plugins/root-relative-urls is very, very helpful | |
| Jan 26, 2011 at 3:15 | comment | added | Manzabar | @NetConstructor.com The SQL statement mireille gave you above is the generic MySQL command for replacing a string in a specific field in a specific table. If you tried running this statement exactly as it was written, it wouldn't work. For this command to work, you'd need to change the TABLE_NAME & FIELD_NAME to a real field and table used by WordPress. | |
| Jan 25, 2011 at 12:03 | comment | added | NetConstructor.com | Thanks... yeah I will do that next time. The SQL statement does a find replacement on the entire database (including all tables)? | |
| Jan 25, 2011 at 11:45 | history | answered | mireille raad | CC BY-SA 2.5 |