Directories SQL Query Codes Required for Deleting Listings

Hey,
I have a directory where some spammer has spammed huge number of listings.
Is it possible to delete from phpmyadmin based on these values.

URL TLD = .ru , .ua, .by etc

Example :
1 http:// 007-shop.ru
1 http:// 007.in.ua
1 http:// 00f.net.ru/
1 http:// 017.by

Can someone point me to a list of these queries which can help out in removing listings based on other criteria's.

Regards

 

And I want to remove many spammed .ro submissions ...

 

If there is any ready made mod which directly deletes listings, or has a excellent search option please let us know.

 

I found one

hope it will work

 

Does that just delete the URL or the whole listing ie description, name, email etc etc?

 

this one is ok.
yes it deletes the whole listing.

 

There are numerous listings from sblog.cz
delete from `PLD_LINK` where `URL` like '%xxx.sblog.cz%' < not working

 

you don't need the xxx
put what you are looking for (search query) between the % signs.
delete from `PLD_LINK` where `URL` like '%sblog.cz%'

 

yes, just put your keyword between the %% stings.

 

wow i tried out these options and here are the results.

delete from `PLD_LINK` where `URL` like '%sblog.cz%'
Deleted rows: 1275 (Query took 16.9193 sec)

delete from `PLD_LINK` where `URL` like '%.htm%' [To remove pages submitted with internal links]
Deleted rows: 1664 (Query took 6.8533 sec)

delete from `PLD_LINK` where `URL` like '%.net%'
Deleted rows: 2481 (Query took 2.2557 sec)

delete from `PLD_LINK` where `URL` like '%.at%'
Deleted rows: 330 (Query took 0.2747 sec)

delete from `PLD_LINK` where `URL` like '%.in%'
Deleted rows: 4566 (Query took 2.5624 sec)

delete from `PLD_LINK` where `URL` like '%.vn%'
Deleted rows: 13 (Query took 0.1530 sec)

delete from `PLD_LINK` where `URL` like '%.ac.uk%'
Deleted rows: 3 (Query took 0.1312 sec)

delete from `PLD_LINK` where `URL` like '%com.au%'
Deleted rows: 238 (Query took 0.2878 sec)

delete from `PLD_LINK` where `URL` like '%ru%'
Deleted rows: 4239 (Query took 1.7641 sec)

delete from `PLD_LINK` where `URL` like '%.cn%'
Deleted rows: 2420 (Query took 1.1714 sec)

delete from `PLD_LINK` where `URL` like '%.edu%'
Deleted rows: 40 (Query took 0.1349 sec)

delete from `PLD_LINK` where `URL` like '%.eu%'
Deleted rows: 136 (Query took 0.1974 sec)

delete from `PLD_LINK` where `URL` like '%.freehostia.com%'
Deleted rows: 21 (Query took 0.1208 sec)

delete from `PLD_LINK` where `URL` like '%.blogspot.com%'
Deleted rows: 563 (Query took 0.5422 sec)

delete from `PLD_LINK` where `URL` like '%.exploreamericaonline.com%'
Deleted rows: 8 (Query took 0.1244 sec)

Wiped off almost 20000 listings

Thanks guys

 

Any query code where description has
[ URL = http:// luggageb.isgreat.org/ Backpacks/backpack-high-laptop-sierra.html]backpack high laptop sierra [ /URL]

DELETE FROM `PLD_LINK` WHERE `DESCRIPTION` LIKE '%[URL=%' << would work?

 

wow this can make my editors job more easy because he had to manually delete all these spam listings, and finally i had removed around 50% of these spam using the command and now he can visit the other websites and review them manually one by one. May be my mistake i always kept the directory for free @ Worlds Biggest Directory

 

Amit, definitely NOT a good thing you've done above.

you just deleted every .net domain you had in your directory by using the '%.net%' - ex: www . topix . net

'%ru%' - what if my site was www . rugrats . com ? gone

%.at%' - www.att.com - gone


etc etc, I'm sure you get the point.

back up everything before you run these queries.

 

I had a backup already, because i would not risk something this way
Also i removed those tld URL's which were full of auto spam of porn, casino etc. The left out 15-20k ranged listings will be manually edited now.

 

OK, just making sure.

 

It got heavily spammed in the last 3 months which is the time i didnt check it out. Captcha was Off