[codemonkey]

you may wish to try this :

update npc_types set bodytype=0 where bodytype is null OR bodytype=-1;