Akismet is having one hell of a time right now filtering out some of the spam I have been getting lately, so I had to manually run a SQL query to kill a bunch of spams. Here's a simple command you can run in your MySQL server to get rid of them: UPDATE wp_comments SET comment_approved = 'spam' WHERE comment_ID BETWEEN startIdNumber AND endIdNumber. You have to first run the commend SELECT * FROM wp_comments ORDER BY comment_ID DESC to find the latest spams, and substitute the appropriate numbers for startIdNumber and endIdNumber. In my case it was BETWEEN 2053 AND 2062.
March 2010
Recent Entries
- A window into the totalitarian mind of the left on freedom of religion
- From Digg: Me: I'm not going to hold my breath waiting for the same liberal democrats who shriek about the…
- By Mike | Comments (7)
- Google's lossy compiler
- Google's closure compiler service gets a little too frisky under ADVANCED_OPTIMIZATIONS. Original code: With advanced optimizations enabled, it was able…
- By Mike | Comments (0)
- The three purposes of the federal income tax law
- Businesses will spend about 3.4 billion man-hours and individuals about 1.7 billion hours figuring out their taxes this year.…
- By Mike | Comments (6)
Subscribe
Advertisements
Monthly Archives
- March 2010 (16)
- February 2010 (17)
- January 2010 (15)
- December 2009 (9)
- November 2009 (2)
- October 2009 (16)
- September 2009 (29)
- August 2009 (22)
- July 2009 (18)
- June 2009 (32)
- May 2009 (38)
- April 2009 (41)
- March 2009 (43)
- February 2009 (51)
- January 2009 (51)
- December 2008 (44)
- November 2008 (52)
- October 2008 (58)
- September 2008 (51)
- August 2008 (53)
- July 2008 (44)
- June 2008 (46)
- May 2008 (36)
- April 2008 (38)
- March 2008 (68)
- February 2008 (44)
- January 2008 (56)
- December 2007 (45)
- November 2007 (18)
- October 2007 (41)
- September 2007 (40)
- August 2007 (24)
- July 2007 (35)
- June 2007 (43)
- May 2007 (36)
- April 2007 (33)
- March 2007 (50)
- February 2007 (54)
- January 2007 (54)
- December 2006 (43)
- November 2006 (31)
- October 2006 (37)
- September 2006 (30)
- August 2006 (52)
- July 2006 (36)
- June 2006 (30)
- May 2006 (58)
- April 2006 (47)
- March 2006 (60)
- February 2006 (65)
- January 2006 (17)
- December 2005 (20)
- November 2005 (4)
OpenID accepted here
Learn more about OpenID
[...] Esta solución la encontre después de buscar la manera más sencilla de eliminar cientos de mensajes escoria desde una consulta en SQL. [...]