/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 vote134 views2 answers
Mysql slave status
SQL
0 vote137 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
3 votes145 views1 answer
Laravel database Using Named Bindings
SQL
2 votes169 views3 answers
Sql function
SQL
17 votes161 views5 answers
Order by sql
SQL
0 vote175 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote136 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
2 votes198 views2 answers
Postgres drop column if exists
SQL
2 votes155 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote144 views1 answer
Split string by comma in sql server
SQL