/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 vote207 views1 answer
Modifier une valeur sql
SQL
7 votes194 views2 answers
Phpmyadmin change password
SQL
0 vote175 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote191 views1 answer
Define a variable in mysql from select
SQL
0 vote169 views1 answer
Docker export psql sql
SQL
0 vote152 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote162 views1 answer
Drop table if exists oracle
SQL
0 vote169 views1 answer
How to check even or odd in sql
SQL
0 vote165 views1 answer
Mysql add root password
SQL
0 vote193 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL