/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

3 votes102 views2 answers
Mysql sum with condition
SQL
0 vote212 views1 answer
Sql server is not
SQL
0 vote363 views1 answer
Sql datum formatieren
SQL
0 vote145 views1 answer
How to check oracle index table
SQL
0 vote150 views2 answers
Sqlite
SQL
1 vote172 views2 answers
Sql where is not number
SQL
0 vote148 views1 answer
Python mysql query where
SQL
8 votes158 views1 answer
Oracle all_source package body
SQL
10 votes147 views1 answer
Create table oracle
SQL
13 votes151 views2 answers
Oracle select into and inner join
SQL