Hi,
No, that wouldn't work. The CatLinks table has two columns, LinkID, and CategoryID. It maps which links are in which categories. If you delete Links, but don't delete the entries out of the CatLinks table, you end up with categories thinking they have too many links in them.
The following query would give you a list of "orphaned" id's. ID's in the category table, that don't have an entry in the links table:
SELECT LinkID
FROM lsql_CatLinks LEFT OUTER JOIN lsql_Links ON (LinkID = ID)
WHERE ID IS NULL
You then need to get all those ID's that are returned and do:
DELETE FROM lsql_CatLinks WHERE LinkID IN (1,2,3,4,5)
where 1,2,3,4,5 is a comma separated list of links. =)
You can also use the admin panel to do these sort of deletions, and it will clean up after itself. Enter in the word 'bad_word' in the title field, and make sure the operator is set to Like. Then set Max hits really high (say 500) and do a search. At the bottom is a check all box which you can check all the links, and then hit delete.
Cheers,
Alex
--
Gossamer Threads Inc.