Getting rid of URLs in the database

Post Reply
User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Getting rid of URLs in the database

Post by Thunderstone »



Hi!

I'm having this extremely annoying problem of not being able to delete
sites from the database.

I try to delete the entire host by deleting in the html, refs and todo
tables. Like this

delete from html where Url like '%www.hostname.com/%'


This seem to work, but then gw starts to index pages from www.hostname.com...

Is there another table I should take care of? Is the "like %" not the
correct matching strategy? Should I use "matches" instead?


/Johan

(BTW, is this not the address to the support mailing list? I really benefit
from the collection of solution presented there. It's simply a great
resource and I think it's sad that it doesn't get all the content it can.
Just my 2c)



User avatar
Thunderstone
Site Admin
Posts: 2504
Joined: Wed Jun 07, 2000 6:20 pm

Getting rid of URLs in the database

Post by Thunderstone »




% is for "matches" not "like"

delete from html where Url matches 'www.hostname.com%'


Yes. This is the place.


Post Reply