805462 - delete spam comments from bug 594543

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[:glob ✱]

delete spam comments from bug 594543 -- comments 39, 40, and 41

sanity check:

SELECT * FROM longdescs WHERE comment_id IN (6762044,6762049,6762050)

delete:

DELETE FROM longdescs WHERE comment_id IN (6762044,6762049,6762050)



thanks.

Comment 1

[Sheeri Cabral [:sheeri]]

SELECT showed me spam of cheap gold, guild gold, etc.


mysql> DELETE FROM longdescs WHERE comment_id IN (6762044,6762049,6762050)
    -> ;
Query OK, 3 rows affected (0.01 sec)