EKsumic's Blog

let today = new Beginning();

Click the left button to use the catalog.

OR

【SQL语句】垃圾评论清理

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%';

 

This article was last edited at 2024-01-13 12:38:48

* *