update records set name = SUBSTRING_INDEX(name,'.',1)  where domain_id not in (1,2,3)