I am looking for a way to search and replace some words in my database.
I have many posts on one of my blog and i want to replace words using regexes.
before publishing, I marked every place I wish to delete/replace with a text XXXX and another part with YYYY
Now I have words within XXXX and YYYY.
XXXX todays news will never end. YYYY
now I want to delete/replace all the words from XXXX to YYYY
Some of the words are in new paragraph, but are still marked with XXXX and YYYY at the end of every word.
I have checked out plugins and sql database code, but all of them are just specific word replacer, I need to replace from X to Y
thanks in advance.