Yay!
UPDATE `mt_entry` SET `entry_allow_comments` = 0 WHERE `entry_authored_on` < DATE_SUB( CURDATE( ) , INTERVAL 30 DAY )
I hate comment spam.
Results tagged “sql” from deskmerc.com
SQL
Static Pages
Blogroll
Monthly Archives
- April 2010 (4)
- September 2009 (1)
- July 2009 (1)
- June 2009 (1)
- May 2009 (3)
- April 2009 (3)
- March 2009 (1)
- February 2009 (1)
- January 2009 (3)
- December 2008 (6)
- November 2008 (7)
- October 2008 (2)
- September 2008 (8)
- August 2008 (6)
- May 2008 (7)
- April 2008 (3)
- March 2008 (4)
- February 2008 (14)
- January 2008 (5)
- September 2004 (9)
- August 2004 (23)
- July 2004 (22)
- June 2004 (27)
- May 2004 (17)
- April 2004 (14)
Categories
Uploaded Stuff
Search
Tags
September 2010
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 |