Thread: Best way to delete 12,000 wordpress comments?
View Single Post
Old 02-10-2009, 05:05 AM  
darksoul
Confirmed User
 
darksoul's Avatar
 
Join Date: Apr 2002
Location: /root/
Posts: 4,997
Quote:
Originally Posted by GrouchyAdmin View Post
delete from wp_comments where 1=1;
Code:
delete from wp_comments where comment_approved=0;
__________________
1337 5y54|)m1n: 157717888
BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN
Cambooth
darksoul is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote