/SQL/Sql select all tables from database change url

Sql select all tables from database change url

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: stackoverflow.com

Similar codes

34 votes224 views6 answers
Install mysql client ubuntu
SQL
0 vote241 views1 answer
Sqlite trim
SQL
0 vote237 views1 answer
Oracle list datafiles
SQL
1 vote241 views1 answer
Convert epoch to date in sql server
SQL
1 vote229 views1 answer
Oracle apex version view
SQL
0 vote257 views2 answers
Postgresql variable in query
SQL
8 votes242 views4 answers
Postgresql server restart
SQL
0 vote230 views1 answer
Test the postgresql db connection
SQL
1 vote236 views1 answer
Oracle schema size
SQL
1 vote232 views3 answers
Sql select only time from datetime
SQL