It sounds like you are making changes to your WordPress posts directly in the MySQL database, and then when you visit the site, the changes are not immediately reflected. In order to see the changes you have made, you need to click the “Update” button for each post.
If you want to refresh all of the posts on your site at once, without having to click the “Update” button for each one, there are a few things you can try:
You can try using a plugin like “WP-Optimize” or “WP Fastest Cache” to clear the cache on your site. This can sometimes help to refresh the content and make the changes you made in the database more visible.
You can also try manually purging the cache on your site. Depending on your hosting provider and the caching plugin you are using, you may be able to do this through the hosting control panel or by accessing the plugin’s settings.
If you are using a caching plugin, you can try disabling it temporarily to see if that helps the changes you made in the database to be more visible.
If none of the above solutions work, you may need to consider manually updating each post by clicking the “Update” button. Alternatively, you could try using the WordPress REST API to update the posts in bulk, rather than making the changes directly in the database.
I hope this helps! Let me know if you have any other questions.
