Change the WordPress site URL from the database

SnippetSeptember 6, 2011

UPDATE wp_options
   SET option_value = 'http://shop.example.com'
 WHERE option_name IN ('siteurl', 'home');