delete from html

[Thunderstone]

I am using this statement to remove files from database

nohup gw -st -d/u1/data/user "delete from html where Url like
'/abacus.bates.edu'"


I have a large number of files, and this process is taking a long time to
remove files one-by-one


Is there a faster method to remove multiple files?

Thanks

Mike Clark
super@101super.com

[Thunderstone]

It looks like you're deleting by the site name which is the first part
of the url. You can take advantage of the url index my using matches
instead of like:
gw -st -d/u1/data/user "delete from html where Url matches 'abacus.bates.edu%'"