/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 vote204 views1 answer
Not between mysql
SQL
0 vote211 views1 answer
Primary key multiple colums
SQL
0 vote216 views1 answer
Alter column to not null with default value sql server
SQL
0 vote201 views1 answer
When mysql server would not work in xampp
SQL
1 vote227 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
5 votes194 views1 answer
Oracle list packages
SQL
1 vote204 views1 answer
How to change owner in postgres
SQL
0 vote193 views1 answer
Python mysql query where
SQL
1 vote216 views2 answers
Procedure syntax
SQL
1 vote221 views2 answers
Mysql switch case
SQL