Archive for November, 2010

links for 2010-11-30

0

links for 2010-11-29

0

links for 2010-11-26

0

links for 2010-11-25

0

Mass Delete WordPress Comments Awaiting Moderation

0

With phpmyadmin it is actually pretty simple:

FIRST: make a backup of your database.

The go into phpmyadmin, select your wordpress database, and click the sql tab, and enter the following query:

SELECT *FROM wp_comments WHERE comment_approved =”0″

that should select all X number of records in question (which are probably spam). If you get that number, then do the following query:

delete from wp_comments WHERE comment_approved =”0″

That should delete all pending comments.

links for 2010-11-23

0

links for 2010-11-21

0

links for 2010-11-20

0

links for 2010-11-16

0

links for 2010-11-14

0

links for 2010-11-12

0

links for 2010-11-08

0

links for 2010-11-05

0
Go to Top