Nice way to clean out Gallery2 spam comments.
March 29th, 2009
No comments
Nice way to quickly cleanout Gallery2 spam comments.
>
mysql> delete ce, e, co from g2_ChildEntity ce, g2_Entity e, g2_Comment co where ce.g_id=e.g_id and e.g_id=co.g_id and e.g_entityType=’GalleryComment’ and (co.g_comment like ‘%[url=http://%’)
-> ;
Query OK, 930651 rows affected (1 min 5.68 sec)
mysql>
