magento db update

-- 
SELECT * FROM core_config_data WHERE scope = 'default' AND path LIKE '%secure/base_url%';

SET @DOMAIN = 'magento.dev';
UPDATE core_config_data SET `value` = CONCAT('https://', @DOMAIN, '/') WHERE path = 'web/secure/base_url';
UPDATE core_config_data SET `value` = CONCAT('http://', @DOMAIN, '/') WHERE path = 'web/unsecure/base_url';

SELECT * FROM core_config_data WHERE scope = 'default' AND path LIKE '%secure/base_url%';