GoFuckYourself.com - Adult Webmaster Forum - Deleting pending comments on wp blog

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Deleting pending comments on wp blog (https://gfy.com/showthread.php?t=1076203)

Deleting pending comments on wp blog

Is there an easier way to delete all my pending comments besides in the wp admin area? I have like 2k comments pending. Need to wipe em out faster than 20 at a time.

Code:

DELETE FROM wp_comments WHERE comment_approved=0

via mysql command

Also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "Screen Options". The default is 20 but I have mine set to 100.

or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/

also a plugin exists do delete them all

http://wordpress.org/extend/plugins/...omment-remove/

Either use Akismet's 'delete all' button if you use that, setting the max in screen options or this in phpMyAdmin but always back up your database before doing it:

DELETE FROM wp_comments WHERE comment_approved = 0

Note: If your comments table is prefixed with wp_something will need to use the correct table name.
:upsidedow

Quote:

Originally Posted by fris (Post 19086422)

also a plugin exists do delete them all

http://wordpress.org/extend/plugins/...omment-remove/

That too
:thumbsup

Quote:

Originally Posted by fris (Post 19086313)

Code:

delete from wp_comments where comment_approved=0

via mysql command

Quote:

Originally Posted by suziqt (Post 19086413)

also, if you are not comfortable with fris's solution, you can change the amount of comments that appear under "screen options". The default is 20 but i have mine set to 100.

Quote:

Originally Posted by papill0n (Post 19086421)

or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/

Quote:

Originally Posted by colmike7 (Post 19086423)

either use akismet's 'delete all' button if you use that, setting the max in screen options or this in phpmyadmin but always back up your database before doing it:

Delete from wp_comments where comment_approved = 0

note: If your comments table is prefixed with wp_something will need to use the correct table name.
:upsidedow

thank you all!