WordPress.org

1. zigx
   Member
   Posted 4 years ago #

   Hi Guys,

   I have a TON of posts and i would basically like to forward date everything by a year... is there an easy/simple way i can do this?

2. whooami
   Member
   Posted 4 years ago #

   phpmyadmin:

   http://wordpress.org/support/topic/132972?replies=5

   I explained how in there.

3. zigx
   Member
   Posted 4 years ago #

   i just bumped the thread.

4. whooami
   Member
   Posted 4 years ago #

   whats the problem?

   You said you wanted to do all of them ("everything" means all of them) -- you dint need to filter anything if you are changing ALL of them.

   UPDATE 'wp_posts' SET post_date= '2007-08-15 10:30:11', post_date_gmt='2007-08-15 10:30:11'

   change the dates as needed.

5. zigx
   Member
   Posted 4 years ago #

   Right.... but this will set all posts with a specific date to another specific date right?

   I need to make each post pushed forward by 1 year... they were not all created @ the exact same time, so the query above wouldn't work i dont think?

   thank you for posting it however.

6. whooami
   Member
   Posted 4 years ago #

   ahh I follow...no thats a slightly more complicated mysql query and one that I am not able to worry about right this second because I am also playing online poker.

7. zigx
   Member
   Posted 4 years ago #

   lol ok well thanks, and i hope you win.

8. whooami
   Member
   Posted 4 years ago #

   ill let you know, right now im in 4th.

9. zigx
   Member
   Posted 4 years ago #

   Can anyone help with this? (thank you!)

10. KarmaSamten
    Member
    Posted 4 years ago #

    Yes, I want to know this too.

    My original three is at http://wordpress.org/support/topic/132972?replies=5#post-611608

    Thanks

Topic Closed

This topic has been closed to new replies.