Database search replace (post content only)

[discobot]

i’m aware of Access database in dashboard but i think this is a little different in that it could be useful to a wider audience with far less risk

the idea here is to be able to search-replace post/page content in the db

perhaps one has a habit of misspelling stuff (a lot vs. alot vs. allot) and wants to do replacements site-wide

an advanced option could enable RegEx support

---

Read-only archive: Issues · ClassicPress/ClassicPress · GitHub

Author: classyMan

Vote count: 1

Status: open

---

Comments

I think this is an advanced option for advanced users, it would be very easy to break the site using this function.

An excellent solution for this already exists: wp search-replace | WP-CLI Command | WordPress Developer Resources

~ posted by James Nylen

hi James - the solution you linked to is for advanced users that could easily break a site (and requires the CLI plugin) - what i’ve proposed here is a dummy resistant search/replace function for ‘normies’ - it would work only with post content, so i’m not sure how one would break a site

maybe this isn’t something the majority would want, but i wanted to make it clear that there’s a big difference between our proposals

~ posted by classyMan

it would work only with post content

OK, yes, that is a very different proposal and I agree that is pretty unlikely to break things. Sorry I missed that distinction the first time around.

~ posted by James Nylen

I like the idea of a search/replace for posts/pages (mostly for when moving sites to a new URL,) but, could see some issues with a feature like this. Using the example in the OP, if you replace the string allot, even just in posts/pages, you might be screwing up a sentence (or even a class name) that contains the word ballot or allotment in it. Just an example.

~ posted by Code Potent

[viktor]

This is a great feature for a plugin.