Thread Starter
zigx
(@zigx)
i just bumped the thread.
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.
Thread Starter
zigx
(@zigx)
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.
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.
Thread Starter
zigx
(@zigx)
lol ok well thanks, and i hope you win.
ill let you know, right now im in 4th.
Thread Starter
zigx
(@zigx)
Can anyone help with this? (thank you!)