/SQL/Find and replace query in wordpress\

Find and replace query in wordpress\

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 vote157 views3 answers
Mysql Server Start
SQL
1 vote149 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote104 views1 answer
Copy table dbeaver
SQL
19 votes152 views5 answers
Date between in mysql
SQL
1 vote266 views1 answer
Sql injection
SQL
0 vote143 views1 answer
Mysql database is not starting in xampp
SQL
2 votes154 views1 answer
SQL IF ELSE
SQL
0 vote196 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote182 views1 answer
Sql developer sql worksheet not showing
SQL
4 votes156 views1 answer
Oracle error compilation line
SQL