/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

16 votes300 views1 answer
CTE statement sql server
SQL
0 vote309 views1 answer
Mysql grant user wildcard database
SQL
0 vote322 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote328 views1 answer
Provide hardcoded value in the mysql query
SQL
4 votes303 views1 answer
Postgresql change default value
SQL
1 vote327 views1 answer
How to test for sql injection
SQL
0 vote285 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote339 views1 answer
Sql missing values
SQL
-1 vote301 views1 answer
Sql syntax create timestamp column
SQL
0 vote317 views1 answer
Oracle shrink table
SQL