Opthumb

mysql wordpress site url change

Mysql statement for changing site url:

UPDATE {table_prefix}wp_options SET option_value = replace(option_value, ‘http://oldlocation’, ‘http://newlocation’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;