Forum
Find and Replace the CMS content - possible?
My site has a phrase "XYZ-ABC" and I want to change it across all content in the database to "XYZABC", just removing the hyphen. I haven't seen a way to do this in the system. I'd like to avoid manually doing a find-and-replace in the database tables....feel like that could get hairy.
Do you have a solution for finding and replacing something across all content?
There's nothing like that in Perch, no.
Hi Leigh, I think I would export the database as a .sql file and then open the file in a code editor and do a find and replace. Then save as a new file. Then re-load up to the database, keeping a copy of the original just incase.
Please don't do that. Nothing good is likely to come of messing around in the database export and we can't support installations where people are doing that as the chance of your data ending up in a mess is reasonably high.
Thanks @simon - as I suspected, Rachel has confirmed what I thought....too risky to edit the SQL file. Manual content editing will be safer. Thanks everyone!