Best way to mass delete wordpress post by DATE? - GoFuckYourself.com

tonyparra · 07-15-2011, 07:36 AM

Ive been googling and binging and decided to delete about half of the 13k post i have on a blog install. I have about 300-400 or so handwritten post that are being treated like the other few thousand rss fed splog post. So i want to delete all post the were created before 2008, i have post dating back to 2004 and the domain was first created in 2008 (i bought off someone) How do i accomplish this is there a plugin or script? Google hasnt been helpful maybe its the terms im using.

tonyparra · 07-15-2011, 07:42 AM

i like to be on top!

Best-In-BC · 07-15-2011, 07:58 AM

who doesnt

tonyparra · 07-15-2011, 07:59 AM

Quote:

Originally Posted by Best-In-BC

who doesnt

*edit* i wish i could touch those tits in your avatar they are... mesmerizing..

over38 · 07-15-2011, 08:06 AM

PhpMyAdmin

tonyparra · 07-15-2011, 08:10 AM

Quote:

Originally Posted by over38

PhpMyAdmin

details?

also this is a wordpress multisite install

Juicy D. Links · 07-15-2011, 08:17 AM

Quote:

Originally Posted by tonyparra

details?

also this is a wordpress multisite install

Sql Query

http://lmgtfy.com/?q=wordpress+sql+q...+posts+by+date

AaronM · 07-15-2011, 08:21 AM

One very easy solution.

http://bluecowhosting.com/blog/wordp...on-seo-plugin/

It has an option to set an expiration for the post date based on any given number of days. In my case, I set it for 14 days and after those two weeks, the post date is automatically removed. It does the same to all posts that are already older than 14 days.

V_RocKs · 07-15-2011, 10:29 AM

Quote:

Originally Posted by AaronM

One very easy solution.

http://bluecowhosting.com/blog/wordp...on-seo-plugin/

It has an option to set an expiration for the post date based on any given number of days. In my case, I set it for 14 days and after those two weeks, the post date is automatically removed. It does the same to all posts that are already older than 14 days.

You drink good liquor and give good infos...

AaronM · 07-15-2011, 08:57 PM

Quote:

Originally Posted by V_RocKs

You drink good liquor and give good infos...

Thanks for noticing.

tonyparra · 07-16-2011, 03:02 AM

Quote:

Originally Posted by AaronM

One very easy solution.

http://bluecowhosting.com/blog/wordp...on-seo-plugin/

It has an option to set an expiration for the post date based on any given number of days. In my case, I set it for 14 days and after those two weeks, the post date is automatically removed. It does the same to all posts that are already older than 14 days.

thanks!

07-15-2011, 07:36 AM	#1
tonyparra Confirmed User Industry Role: Join Date: Jul 2008 Location: In your back seat with duck tape Posts: 4,568	Best way to mass delete wordpress post by DATE? Ive been googling and binging and decided to delete about half of the 13k post i have on a blog install. I have about 300-400 or so handwritten post that are being treated like the other few thousand rss fed splog post. So i want to delete all post the were created before 2008, i have post dating back to 2004 and the domain was first created in 2008 (i bought off someone) How do i accomplish this is there a plugin or script? Google hasnt been helpful maybe its the terms im using. __________________ High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot

07-15-2011, 07:42 AM	#2
tonyparra Confirmed User Industry Role: Join Date: Jul 2008 Location: In your back seat with duck tape Posts: 4,568	i like to be on top! __________________ High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot

07-15-2011, 07:58 AM	#3
Best-In-BC Confirmed User Join Date: Jun 2002 Posts: 9,506	who doesnt __________________ Vacares - Web Hosting, Domains, O365, Security & More Unparked domains burning a hole in your pocket? 5 Simple Ways to Make Easy $$$ from Unused Domains

07-15-2011, 08:06 AM	#5
over38 Confirmed User Industry Role: Join Date: Aug 2002 Location: USA Posts: 460	PhpMyAdmin __________________ Mainstream Blazing Fast SSD WordPress Hosting As Low As $4.97/month! USA Based Support !

07-15-2011, 08:21 AM	#8
AaronM Too lazy to set a custom title Industry Role: Join Date: Oct 2001 Location: ┌∩┐ ◣_◢ ┌∩┐ Posts: 46,909	One very easy solution. http://bluecowhosting.com/blog/wordp...on-seo-plugin/ It has an option to set an expiration for the post date based on any given number of days. In my case, I set it for 14 days and after those two weeks, the post date is automatically removed. It does the same to all posts that are already older than 14 days. Last edited by AaronM; 07-15-2011 at 08:26 AM..