There are lots of good answers already posted, but if I can make a further suggestion... It is often worth running a SELECT on the WHERE clause you are about

There are lots of good answers already posted, but if I can make a further suggestion... It is often worth running a SELECT on the WHERE clause you are about to use for your UPDATE. That way you can make sure only a limited amount of data comes back before you launch something catastrophic.