how to change image url from http to https in wordpress

Question

Digital certificates

I connect ssl to wordpress. If the site works on https, then there is a problem of mixed content.
How to change image url from http to https in wordpress?

Answer 1

Plugin https://ru.wordpress.org/plugins/search-regex/.
Replacing SQL queries directly in the database can cause various problems with the site.
Moreover, it is better to insert images as protocol-independent links.

Answer 2

SQL query to the database. Just replace with yours

UPDATE wp_options SET option_value = REPLACE (option_value, 'http://old_domain.ru', 'https://new_domain.ru') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://old_domain.ru', 'https://new_domain.ru');
UPDATE wp_posts SET guid = REPLACE (guid, 'http://old_domain.ru', 'https://new_domain.ru');
UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://old_domain.ru','https://new_domain.ru');