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.
-
via mysql commandCode:DELETE FROM wp_comments WHERE comment_approved=0
Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.
-
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.Comment
-
or you can just use the 'delete pending comments' plugin
http://wordpress.org/extend/plugins/...ding-comments/Comment
-
Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.
Comment
-
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.
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..
Comment
-
Join the BEST cam affiliate program on the internet!
I've referred over $1.7mil in spending this past year, you should join in.
I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..Comment
-
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.
thank you all!Comment
Comment