SQL Addition

ok so ive got my sql script al lrinnign fin but i needto make batch updates to a set of rows

UPDATE `cmsquizanswers` SET `QUID` = '42' WHERE `QUID` = '43' AND `MOID` = '46' ;


that wprks fine for changing all items tha t were 43 and 46 to 42 and 46 but i also need to chang e a 3rd field OrderS

for eash of refernece here are the collum names

QQID, QUID, MOID, question, answer, orderS

now for Order S they are set goign in a order of 10, 20, 30, etc per row andi want to change them to 110, 120, 130, is they some way i can say do a

"orderS +100" for all values inside the where range in the order S colum

Sure, you'd do it just the same way.. not sure what you where logic is going to be, so i'll just make something up:

would



work?

yep, but you have 2 equal signs in there, you just need 1, not sure if you miss-typed (which you seem to always do ) or not.

Kurt

I am arguallby credited as the internet's Typo King...

Now there's a custom rank for you!