SQL snippets to bulk update records & soa

pdns-mysql-update-snippets.sql

/* Update SOA records for zones having a certain IP in the content */
UPDATE records
SET `content` = 'ns1.connexeon.com. domains.connexeon.com. 2017040701 1200 400 1209600 300'
WHERE `id` IN
        (SELECT `id`
         FROM records_copy
         WHERE `type`='SOA'
             AND `domain_id` IN
                 (SELECT DISTINCT `domain_id`
                  FROM records_copy
                  WHERE `content` = '85.158.108.156'
                      AND `type`='A') );

/* Update A records */
UPDATE records
SET `content` = '37.97.167.93'
WHERE `content` = '85.158.108.156'
    AND `type`='A';

/* Updating SOA records with an expected serial */
UPDATE records
SET `content` = 'ns1.connexeon.com. domains.connexeon.com. 2017040702 1200 400 1209600 300'
WHERE `content` = 'ns1.connexeon.com. domains.connexeon.com. 2017040701 1200 400 1209600 300'
    AND `type`='SOA';