Wordpress Themes - WP Forum at BFA

Wordpress Themes - WP Forum at BFA (http://forum.bytesforall.com/index.php)
-   Installing & running WordPress (http://forum.bytesforall.com/forumdisplay.php?f=6)
-   -   Deleting multiple entries (http://forum.bytesforall.com/showthread.php?t=497)

HenryGomez Feb 22, 2009 11:07 AM

Deleting multiple entries
 
Another generic wordpress question.

I realized that some of the 11,000 entries I imported from Movable Type were mapped incorrectly to the wrong authors. Probably my mistake. Anyway I've been isolating the months where this occurred and was wondering if there is a way to delete a lot of entries at once.

If I filter the entries by month it only shows me 15 at a time which means that in a busy month I have to delete 15 entries per page time 20 pages. I'd love to delete all the entries in the given month in one fell swoop so I can reimport them (mapped properly).

Flynn Feb 22, 2009 06:56 PM

This should work, if executed in PHPMyAdmin via SQL tab, but only do this if you're brave and if you have a backup of your posts. I tested this query but not in Phpmyadmin, in fact I never used Phpmyadmin, and I cannot guarantee anything

To delete all posts of Jan 2009 (This also assumes that you have not changed your Wordpress table prefix from wp_ to something else, you probably haven't):

Code:

DELETE FROM wp_posts WHERE post_date REGEXP '^2009-01-' AND post_status = 'publish'

HenryGomez Feb 22, 2009 10:24 PM

I just ended up sucking it up and deleting them manually. A plug-in for this would be great.

superstrong Apr 15, 2009 01:59 AM

For future reference, if you want to know how to display more categories per page in Wordpress--especially for bulk deleting--just go into the wp-admin > categories.php file and find this section

Code:

if( ! isset( $catsperpage ) || $catsperpage < 0 )
        $catsperpage = 20;

and change "20" (i.e., display 20 categories per page) to whatever you want.


All times are GMT -6. The time now is 07:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.