/SQL/Wordpress change http to https phpmyadmin

Wordpress change http to https phpmyadmin

UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Source: hostinger.com

Similar codes

0 vote153 views2 answers
Sql query for getting details by id
SQL
0 vote192 views1 answer
Call function sql oracle with output put line
SQL
0 vote163 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote141 views1 answer
Update having mysql
SQL
1 vote166 views1 answer
Postgres see sequence current state
SQL
0 vote155 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote149 views1 answer
Oracle simple quote
SQL
3 votes206 views1 answer
How to get yesterday date in sql
SQL
38 votes215 views4 answers
Count sql
SQL
1 vote156 views1 answer
SQL date part only of datetime
SQL