How to change all the emails from subdomains? Print

If you have installed Blesta on a subdomain and you get billing@subdomain.domain.com but you want them to be changed to billing@domain.com? You can run the following in PHPMyAdmin:
UPDATE `emails` SET `from`='billing@domain.com' WHERE `from`='billing@subdomain.domain.com';
UPDATE `emails` SET `from`='sales@domain.com' WHERE `from`='sales@subdomain.domain.com';
UPDATE `emails` SET `from`='support@domain.com' WHERE `from`='support@subdomain.domain.com';