/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

14 votes294 views1 answer
Sql value of string
SQL
0 vote292 views1 answer
Sql select where more than one record exists
SQL
0 vote279 views1 answer
Display first three characters sql
SQL
0 vote304 views1 answer
Mssql unique key accept nulls
SQL
-1 vote326 views1 answer
Add 10 to all numbers in a column sql
SQL
1 vote296 views1 answer
Regular expression in sql server
SQL
0 vote294 views1 answer
OFFSET consulta mysql
SQL
0 vote267 views1 answer
Get duplicate entry sql
SQL
0 vote299 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote284 views1 answer
Sqlite commands
SQL