I've done something like this multiple times... in fact I think we posted a few threads on how to do this a few months back.
But, using Alex's suggestion, the trick is to find the link ID's.
What you do, is execute a
SELECT ID FROM Links WHERE ....
The ... is the criteria you want. If you do this from the SQL monitor, not MySQLMan, you'll be able to select the list of ID's, and paste it into a text editor, then add a ',' at the end of each line, and wrap the whole shebang in a pair of ()'s.
This becomes your IN (....list....) for the query.
MySQLMan table-izes it, while SQL Monitor just outputs it to the screen.
If you use something like EditPlus, you can replace on a regex -- '\n' -- with ',\n' -- and that will create the list, just add the () to it.
If you want more suggestions, I know there was a thread or two about this earlier in the year, with examples of SQL for inserting, moving and updating the CatLinks table. You might find it by searching for something like 'insert into catlinks' or similar.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Plugins:http://LinkSQL.com/plugin
But, using Alex's suggestion, the trick is to find the link ID's.
What you do, is execute a
SELECT ID FROM Links WHERE ....
The ... is the criteria you want. If you do this from the SQL monitor, not MySQLMan, you'll be able to select the list of ID's, and paste it into a text editor, then add a ',' at the end of each line, and wrap the whole shebang in a pair of ()'s.
This becomes your IN (....list....) for the query.
MySQLMan table-izes it, while SQL Monitor just outputs it to the screen.
If you use something like EditPlus, you can replace on a regex -- '\n' -- with ',\n' -- and that will create the list, just add the () to it.
If you want more suggestions, I know there was a thread or two about this earlier in the year, with examples of SQL for inserting, moving and updating the CatLinks table. You might find it by searching for something like 'insert into catlinks' or similar.
PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Plugins:http://LinkSQL.com/plugin
