/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

1 vote147 views2 answers
Intersect sql
SQL
1 vote127 views1 answer
Sql order by where condition
SQL
1 vote120 views1 answer
How to select random rows from table
SQL
1 vote124 views2 answers
Postgres cast as decimal
SQL
0 vote127 views1 answer
Display first three characters sql
SQL
0 vote140 views1 answer
Count database access django
SQL
0 vote125 views1 answer
Number(10 2) in sql means
SQL
8 votes116 views1 answer
Alter tablespace add datafile
SQL
11 votes197 views2 answers
Sql between date range
SQL
4 votes132 views2 answers
Delete all table oracle
SQL