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

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):

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

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

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

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

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