Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

SQL query to assign category

Oct 14, 2001, 7:48 PM
surfsafely
User (119 posts)
Oct 14, 2001, 7:48 PM
Views: 2375
Shortcut
Quote Reply
SQL query to assign category
Having started out with a database of records that were originally imported to my Links table using MySQLMan, none of the original records had any category assignments. Links will only export records which have been assigned to categories.

What I need is a SQL query that will assign all links without a category to a category named Default and leave all others alone. Can anyone help with this?
Subject Author Views Date
Thread SQL query to assign category surfsafely 2375 Oct 14, 2001, 7:48 PM
Post Re: [surfsafely] SQL query to assign category 		Stealth 2173 Oct 14, 2001, 8:30 PM
Thread Re: [surfsafely] SQL query to assign category 		Alex 2130 Oct 15, 2001, 8:51 AM
Post Re: [Alex] SQL query to assign category 		surfsafely 2129 Oct 15, 2001, 5:32 PM