/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 votes105 views3 answers
Start postgresql ubuntu
SQL
0 vote110 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote107 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote111 views1 answer
PGSQL dynamic table name
SQL
1 vote116 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote104 views1 answer
Sql select with apostrohpe
SQL
0 vote98 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote102 views1 answer
Show indices in mysql table
SQL
0 vote107 views1 answer
Kill slow queries mysql
SQL
16 votes108 views2 answers
Oracle ddl
SQL