/SQL/Wordpress database query change url

Wordpress database query change url

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

Source: wpbeaches.com

Similar codes

0 vote135 views1 answer
Mysql select where field like in list
SQL
6 votes140 views2 answers
Mysql first day of month
SQL
0 vote137 views1 answer
Start and stop mysql
SQL
0 vote141 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote152 views1 answer
Mysql show database size in mb
SQL
0 vote144 views1 answer
Flexible search query delete table
SQL
0 vote136 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote135 views1 answer
Sql roll up rows into columns
SQL
0 vote166 views1 answer
When mysql server would not work in xampp
SQL
1 vote85 views1 answer
File /etc/init.d/mysql not exists
SQL