/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

1 vote316 views2 answers
Drop table if exists test
SQL
0 vote409 views1 answer
Delet all record statment sql
SQL
1 vote310 views1 answer
Last 6 months postgresql
SQL
16 votes315 views3 answers
Delete row psql
SQL
2 votes308 views1 answer
Sql server find table name
SQL
2 votes333 views1 answer
Search query in mysql
SQL
0 vote321 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
13 votes306 views2 answers
Check if value is null mysql
SQL
12 votes306 views1 answer
Env var for setting password for root user mysql docker hub
SQL
3 votes327 views3 answers
Order by postgres
SQL