UPDATE EventTable
SET Details = ''  -- this is two consecutive single quotes
WHERE EventType = 29 /* Residence fact */
AND Details LIKE '%Age:%' OR
                 Details LIKE '%StreetAddress:%' OR -- etc.
                 Details LIKE '%Census%' OR
                 Details LIKE '%StreetAddress:%' OR
                 Details LIKE '%Residence Post Office:%' OR
                 Details LIKE '%Marital Status:%' OR
                 Details LIKE '%GradeCompleted:%' OR
                 Details LIKE '%OccupationCategory:%' OR
                 Details LIKE '%Occupation:%' OR
                 Details LIKE '%EnumerationDistrict:%' OR
                 Details LIKE '%AttendedSchool:%' OR
                 Details LIKE '%ClassofWorker:%' OR
                 Details LIKE '%Relation to Head%' OR
                 Details LIKE '%PartyAffiliation:%';