Replace locales of dataobjects in Silverstripe. Handy if you want to duplicate a site in a new language, but want to keep the old content as a starting point

replacetranslations.sql

// Returns list of tables which has a Locale column
SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('Locale')
        AND TABLE_SCHEMA='SS_mydatabase';

// Replace the locale en_NZ with en_US
UPDATE `ATableFromAbove` set `Locale` = "en_US" WHERE `Locale` = "en_NZ";