WordPress.org

Ready to get started?Download WordPress

Forums

Feature req: bulk changing date (3 posts)

  1. substitute
    Member
    Posted 4 years ago #

    Hi
    Yeah what if you have dozens of posts you want to set to another date?
    You have to it one by one...
    Would be good to be able to that in one go.

    Thanks

  2. MichaelH
    Member
    Posted 4 years ago #

    Until that gets added to core, here's one example of doing it with MySQL commands in something like phpMyAdmin

    SQL to increment dates in wp_posts

    UPDATE wp_posts
    SET post_date = DATE_ADD( post_date, INTERVAL 9 MONTH ),
    post_date_gmt = DATE_ADD( post_date_gmt, INTERVAL 9 MONTH ),
    post_modified = DATE_ADD( post_modified, INTERVAL 9 MONTH ),
    post_modified_gmt = DATE_ADD( post_modified_gmt, INTERVAL 9 MONTH )
  3. substitute
    Member
    Posted 4 years ago #

    Nice but I wouldn't know how to do that. I'll just wait for the core to be updated if ever.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.