Replacing WordPress URLs with SQL command

WARNING – Always make a backup before modifying your database.

This came really handy when you have to manually migrate a WordPress website to another domain.

Remember that in some cases table prefix is not the standard “wp”, but it may change (and actually it is good practice), so remember to check that before running it.

Posted in Code Tricks, Transact SQL and tagged , , , , .

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.