If you just want to "move" the links from one category to the other, so there is one Games_and_Books category, then delete the other:

If the two ID's are 1 and 2, and you want to keep category 2, then you want to move the links from category 1 to category 2:

UPDATE Links SET CategoryID=2 WHERE CategoryID=1

This will "move" any _links_ that are in Category 1 to now be in Category 2.

This will work as long as there are no subcategories in Category 1. If there are, you'd need to go in and edit any of the subcategory names in the Category table from:

Games/ and change that to Games_and_Books/

If you only have a few, you can do that from the Links Admin menu. If you have a lot of them, you'd want to do a REPLACE function on them.


http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/