Android Contacts – Update Company Name

UPDATE data
SET data1 = "<Company Name>"
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%organization%"
		)
	AND data1 LIKE "%<Company Name>%";

UPDATE data
SET data1 = "<Company Name>"
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%organization%"
		)
	AND raw_contact_id IN (
		SELECT raw_contact_id
		FROM data dt1
		INNER JOIN mimetypes ON mimetype_id = mimetypes._id
		WHERE mimetype LIKE "%email%"
			AND raw_contact_id IN (
				SELECT raw_contact_id
				FROM data dt1
				INNER JOIN mimetypes ON mimetype_id = mimetypes._id
				WHERE mimetype LIKE "%email%"
					AND data1 LIKE '%<Company Email Domain>%'
				)
		);

UPDATE data
SET data1 = "<Company Name>"
WHERE mimetype_id IN (
		SELECT _id
		FROM mimetypes
		WHERE mimetype LIKE "%organization%"
		)
	AND (
		data1 LIKE "%<Company Name>%"
		OR raw_contact_id IN (
			SELECT raw_contact_id
			FROM data dt1
			INNER JOIN mimetypes ON mimetype_id = mimetypes._id
			WHERE mimetype LIKE "%email%"
				AND raw_contact_id IN (
					SELECT raw_contact_id
					FROM data dt1
					INNER JOIN mimetypes ON mimetype_id = mimetypes._id
					WHERE mimetype LIKE "%email%"
						AND data1 LIKE '%<Company Email Domain>%'
					)
			)
		);