Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Version 1.x :

Description question

Dec 14, 2000, 11:14 PM
Christa
Novice (47 posts)
Dec 14, 2000, 11:14 PM
Post #1 of 2
Views: 2892
Shortcut
Quote Reply
Description question
hey

I have a strange question...
Is there a way to delete all sites without description in the database?
The manual way will not work since I have over 15,000 links in my database.

I do have a good reasons to do that..


Regards
Christa
Dec 14, 2000, 11:20 PM
pugdog
Veteran / Moderator (6956 posts)
Dec 14, 2000, 11:20 PM
Post #2 of 2
Views: 2786
Shortcut
Quote Reply
Re: Description question In reply to
You can use the SQL monitor

DELETE FROM Links
Where Description = '' or Description IS NULL

You might want to try a "SELECT" rather than a DELETE to see what the where clause will do, since it's permanent.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ