UPDATE data SET data1 = NULL ,data2 = NULL ,data3 = NULL WHERE mimetype_id IN ( SELECT _id FROM mimetypes WHERE mimetype LIKE "%name%" ) AND raw_contact_id IN ( SELECT raw_contact_id FROM data dt1 INNER JOIN mimetypes ON mimetype_id = mimetypes._id WHERE mimetype LIKE "%name%" AND length(data1) > 0 AND data1 LIKE ( SELECT data1 FROM data dt2 INNER JOIN mimetypes ON mimetype_id = mimetypes._id WHERE mimetype LIKE "%organization%" AND length(data1) > 0 AND dt1.raw_contact_id = dt2.raw_contact_id ) );
Last Updated on October 26, 2015