/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

12 votes327 views6 answers
Between in sql
SQL
0 vote413 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
18 votes327 views6 answers
Laravel form validation
SQL
1 vote385 views1 answer
Sql select row with max date
SQL
16 votes344 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
-1 vote336 views3 answers
Compute age mysql
SQL
0 vote328 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote349 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote343 views1 answer
Oracle 11g forget password
SQL
0 vote386 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL