Title: How to replace all "http" hyperlink with "https" in my wordpress posts
Last modified: August 21, 2016

---

# How to replace all "http" hyperlink with "https" in my wordpress posts

 *  [d.stubborn.kanav](https://wordpress.org/support/users/dstubbornkanav/)
 * (@dstubbornkanav)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/how-to-replace-http-hyperlink-with-https/)
 * I have lots of hyperlink of my website starting with “[http://”&#8230](http://”&#8230);.
   Now i want to change all those “http” with “https”
 * From [this](http://abc) to [this](https://abc)
 * i tried a plugin “search and replace”, but it replaced links of my post….i want
   to change the hyperlinks that are in my posts…

Viewing 1 replies (of 1 total)

 *  [linux4me2](https://wordpress.org/support/users/linux4me2/)
 * (@linux4me2)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/how-to-replace-http-hyperlink-with-https/#post-3845325)
 * If your host provides you with phpMyAdmin or some other user interface to run
   MySQL queries, you can do this pretty easily with a MySQL query. For example,
   you would run the following query on an SQL tab in phpMyAdmin:
    `UPDATE wp_posts
   SET post_content = REPLACE(post_content, 'http://yourdomain', 'https://yourdomain')`
   You’ll have to substitute the “wp_” with whatever prefix you’re using for your
   WordPress tables if it’s not “wp_.”
 * The important thing is to include your domain name in the from and to strings
   in the [MySQL REPLACE function](http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_replace)
   so that only the protocol for _your_ domain is changed, not the protocol for 
   links to other sites that may not have SSL.
 * Of course, make sure you back up your database, or at least the wp_posts table
   before you do this unless you’re feeling very confident.
 * You’ll also need to go through your Widgets manually to change the protocol there,
   or you can use relative URLs.

Viewing 1 replies (of 1 total)

The topic ‘How to replace all "http" hyperlink with "https" in my wordpress posts’
is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [linux4me2](https://wordpress.org/support/users/linux4me2/)
 * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/how-to-replace-http-hyperlink-with-https/#post-3845325)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics