I needed to search and replace ALL occurrences of a specific word in all the posts (e.g. "white") and replace it with another word (e.g. "blue").
This was accomplished pretty easily with the plugin called Search-Regex, which is available on the wordpress site as well.
However, although the words "white" is now replaced with the word "blue" this does not manifest on the WP front end until I manually click edit every single post and click "update".
It looks as if WP now uses some kind of cashed versions of the posts and never checks what is in the database. (please note: although I use WP Super Cache for cashing, it is now deactivated and doesn't influence this operation).
Is there a way to automatically update ALL posts in one go so that my search and replace gets done quickly? I have over 1000 posts and updating every single one of them manually is going to be pretty exhausting.