I'm using the below command to move all links in some categories into another category. This only works with 1 category at a time. I need to move links in several categories at the same time. I have a range of category numbers - 120 - 5000 so perhaps this command would involve a wildcard. Any suggestions?

Current Command:

UPDATE CatLinks SET CategoryID = y WHERE CategoryID = x

Where y = to and x = from




________________________
Eraser
Insight Eye
http://www.insighteye.com

Hi,

You can use where

CategoryID LIKE '%n%'

the percents are wildcards, so '3%' would fine 3, 30, 31, .., 39, 300. Just be careful though. =)

Cheers,

Alex

--
Gossamer Threads Inc.