/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

-2 votes143 views1 answer
Create trigger syntax
SQL
0 vote136 views1 answer
How to find date from date table in sql
SQL
1 vote212 views1 answer
Create new table from old table with data
SQL
0 vote140 views2 answers
Script all indexes in a database
SQL
0 vote143 views1 answer
Create table like sql
SQL
0 vote139 views1 answer
Set mysql socket file docker windows
SQL
3 votes126 views3 answers
Print in pl sql
SQL
0 vote134 views1 answer
Not between mysql
SQL
0 vote204 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote162 views1 answer
Wordpress sql find and replace
SQL