Copyright notice: This article is an original article and follows
CC 4.0 BY-NC-ND
Copyright agreement. If you want to repost this article, please attach the original source link and this statement.
Source link:
https://www.v2know.com/MainPage/PreView/692
The SQL statements:
DELETE FROM Comments
WHERE NAME='Evden Eve'
DELETE FROM Comments
WHERE BlogId='127' AND Name!='Nadine Wurth';
DELETE FROM Comments
WHERE BlogId='350';
DELETE FROM Comments
WHERE (NAME REGEXP '[^0-9.]')=0
DELETE FROM Comments
WHERE NAME LIKE '%色情%'
DELETE FROM Comments
WHERE NAME LIKE '%xxx%'
DELETE FROM Comments
WHERE NAME LIKE '%.xyz%'
DELETE FROM Comments
WHERE NAME LIKE '%.com%'
DELETE FROM Comments
WHERE NAME LIKE '%http%'
DELETE FROM Comments
WHERE NAME LIKE '%site%'
DELETE FROM Comments
WHERE NAME LIKE '%л%'
DELETE FROM Comments
WHERE NAME LIKE '%fuck%';
DELETE FROM Comments
WHERE NAME LIKE '%파%';
DELETE FROM Comments
WHERE content LIKE '%http%'
DELETE FROM Comments
WHERE content LIKE '%일%'
DELETE FROM Comments
WHERE content LIKE '%클%'
DELETE FROM Comments
WHERE content LIKE '%Sexy%'
DELETE FROM Comments
WHERE content LIKE '%л%'
DELETE FROM Comments
WHERE content LIKE '%</a>%';
DELETE FROM Comments
WHERE content LIKE '%www%';
DELETE FROM Comments
WHERE content LIKE '%Hi there%';
DELETE FROM Comments
WHERE content LIKE '%.xyz%';
OR Content='@1 555';
SELECT * FROM Comments WHERE BlogId='350';
select * from Comments WHERE NAME='EVDeN EVE';
select * from Comments where (name REGEXP '[^0-9.]')=0;
SELECT * FROM Comments WHERE NAME LIKE '%色情%';
SELECT * FROM Comments WHERE NAME LIKE '%xxx%';
SELECT * FROM Comments WHERE NAME LIKE '%.xyz%';
SELECT * FROM Comments WHERE NAME LIKE '%.com%';
SELECT * FROM Comments WHERE NAME LIKE '%site%';
SELECT * FROM Comments WHERE NAME LIKE '%л%';
SELECT * FROM Comments WHERE NAME LIKE '%파%';
SELECT * FROM Comments WHERE NAME LIKE '%fuck%';
SELECT * FROM Comments WHERE content LIKE '%http%';
SELECT * FROM Comments WHERE content LIKE '%일%';
SELECT * FROM Comments WHERE content LIKE '%클%';
SELECT * FROM Comments WHERE content LIKE '%Sexy%';
SELECT * FROM Comments WHERE content LIKE '%sex%';
SELECT * FROM Comments WHERE content LIKE '%л%';
SELECT * FROM Comments WHERE content LIKE '%</a>%';
SELECT * FROM Comments WHERE content LIKE '%www%';
SELECT * FROM Comments WHERE content LIKE '%.com%';
SELECT * FROM Comments WHERE LENGTH(content)>1000;
SELECT * FROM Comments WHERE BlogId='127' AND Name!='Nadine Wurth';
SELECT * FROM Comments WHERE content LIKE 'Hello%';
SELECT * FROM Comments WHERE content LIKE '%Hi there%';
SELECT * FROM Comments WHERE content LIKE '%porn%';
SELECT * FROM Comments WHERE content LIKE '%.xyz%';