Ok, here is a update statement I have...

UPDATE support_test
SET cat_id=42
WHERE cat_id = 4

It works fine, only thing is I need to update more numbers but I don't want to overwrite the updated numbers. Example, I want to update 42 to 6 but want to update the original 6's to 12. I have about 30+ numbers that need to be changed, any way to go about this?

Hello,

I personnally would use another table (with the same structure as the first one). Instead of your updates, you would do :

Insert into support_test_temp(cat_id, field2, field3) select 42, field2, field3 from support_test where support_test.cat_id=4;

... and so on for each change.

Then :

commit;

delete from support_test;

Insert into support_test select * from support_test_temp;

commit;

And finally get rid of the temp table :

drop table support_test_temp;

Regards,

RBARAER