====== DokuWikiのBlogTNGのスパムコメントをSQLで一層 ====== 作業メモ。 コメント元のIPアドレスをコメント数に並べ替え。 SELECT COUNT(ip), ip FROM comments GROUP BY ip ORDER BY count(ip); IPアドレスと一致するコメントを削除。 DELETE FROM comments WHERE ip='x.y.z.w';
SELECT COUNT(ip), ip FROM comments GROUP BY ip ORDER BY count(ip);
DELETE FROM comments WHERE ip='x.y.z.w';