[Azrealvect]

or would it be better to do something like

UPDATE npc_types SET race = REPLACE(race, '43', '305');

Still new to this and not sure which to use in some situations