Magento: Replace domain / store URLs direct in MySQL (no sed)

magento-store-replace.sql

#Select all the config data with the current domain in the value
select * from core_config_data where value like "%www.old-domain.com%";

#replacing www.old-domain.com with www.new-domain.com
update core_config_data set value=REPLACE(value, 'www.old-domain.com', 'www.new-domain.com') 
where value like "%www.old-domain.com%";

#check if it worked!
select * from core_config_data where value like "%www.new-domain.com%";