/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 votes190 views1 answer
Mysql time ago difference
SQL
0 vote199 views1 answer
Psql attribute cannot login
SQL
0 vote184 views1 answer
Get records in sql according to month name and count
SQL
0 vote203 views1 answer
Convert rows to columns in sql server
SQL
2 votes180 views1 answer
Sql select min value from multiple columns
SQL
1 vote201 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote200 views1 answer
Mysql last 6 months
SQL
0 vote201 views1 answer
Sql reverse order of results
SQL
1 vote215 views1 answer
Mariadb get column names from table
SQL
2 votes201 views3 answers
Oracle show column of table
SQL