Update WordPress Database to Change Post Dates

Delete saved post revisions from database

SELECT * FROM `wp_posts` WHERE post_status != “publish” and post_title like ‘%guest post%’

 

Change the post date or post modified date

Single entry: SELECT * FROM `wp_posts` WHERE post_status = “publish” and post_title like ‘%guest post%’

All: SELECT * FROM `wp_posts` WHERE post_status = “publish” and post_title != “” ORDER by post_date DESC