UPDATE dbtech_thanks_entry SET userid = 'xxx' WHERE userid = 'Old ID'; UPDATE dbtech_thanks_entry SET receiveduserid='xxx' WHERE receiveduserid = 'Old ID';