Updating weapons (SQL Help)

[c0ncrete]

you'll probably want to match the value returned with the data type of the field it's going to be updating. i'm not sure it won't just truncate the result, but it's never a bad idea to cover your bases.

also, this is shorter and more readable:

WHERE `itemtype` IN (1, 2, 3, 4, 5, 35, 45)

[vkrr]

Thanks c0nc,

Any suggestion how I can go about updating these tables?
I have a list of regular items and their fabled counterparts saved, but I'm not really sure how to go about copying one set of values over to the other. (Well, all except name, and ID of course)


That's a lot of information to copy over, there has to be an easy way to do it, but i dont know what it is!