Cacher is the code snippet organizer for pro developers

CREATE TABLE temp_computerDNS (computerid INT(11) NOT NULL, DNSserver VARCHAR(250) NOT NULL, PRIMARY KEY (computerid, DNSserver));
INSERT IGNORE INTO temp_computerDNS (computerid, DNSserver)
SELECT computerid,
       SUBSTRING_INDEX(SUBSTRING_INDEX(c.`DNSInfo`,':',-1),';',1)
FROM computers c;
INSERT IGNORE INTO temp_computerDNS (computerid, DNSserver)
SELECT computerid,
       TRIM(TRAILING ';' FROM SUBSTRING_INDEX(SUBSTRING_INDEX(c.`DNSInfo`,':',-1),';',-2))
FROM computers c;
SELECT * FROM temp_computerDNS;