there is this very old but still valid (I hope) great post about how to lower the TTL for all DNS records prior to a migration: http://forums.interworx.com/threads/1582-Advice-Needed-IP-Migrations?p=9815#post9815
I am not a SQL guy at all, so my question is instead of
UPDATE dns_records SET ttl=200;
I would like to only change those TTL value, that are still on the default of 43200 seconds.
I know there is the CASE statement for SQL, but I can’t write the correct SQL statement. In natural language it would be:
Update all DNS-Records to 200 IF they currently are 43200 ELSE do nothing
Can anybody help me with the correct statement?