50px-Edit-find-replace.svgThe other day I had to move a blog from one server to another and found out that WordPress sometimes likes to hard code the server address into things like links and images.  I found this handy little SQL statement you can run to find and replace anything that you need changed:

update [Table] set [Column] = replace([column],’[old text]‘,’new text’);

This can save you a lot of heart ache dealing with moving servers and find out that you have a lot of broken images left after migration.

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

« »