Support » Requests and Feedback » Feature req: bulk changing date

  • 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.


Viewing 2 replies - 1 through 2 (of 2 total)
  • 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 )

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Feature req: bulk changing date’ is closed to new replies.