/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

0 vote221 views1 answer
View to table
SQL
1 vote193 views1 answer
Raise application error in oracle
SQL
0 vote190 views2 answers
Temp Space
SQL
0 vote214 views10 answers
John the ripper mysql
SQL
0 vote229 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote183 views1 answer
How to find username and password in oracle 18c
SQL
15 votes279 views4 answers
Mysql export database command line
SQL
1 vote239 views1 answer
Select last row from SQL Table
SQL
11 votes200 views2 answers
How to import mysql database command line
SQL
0 vote195 views1 answer
Select * from mysql.proc
SQL