Jon Ashcroft

WordPress URL Replace SQL Wizard

2nd November, 2016

On all of my projects, I’ve been using a very useful WordPress SQL Wizard that I found to replace my WordPress URLs when migrating from the dev environment. It’s great – but if you don’t use the default database prefix, you’ll have to do a find and replace for your prefix (and who has time for that?).

So I decided to fork it.

Here is my Pen for a WordPress URL replace SQL query, which includes the option to enter a custom database prefix.

See the Pen WordPress SQL Wizard by Jon Ashcroft (@jonashcroft) on CodePen.


I want to give full credit of the original Pen and Javascript to djave – all I did was add a few lines of Javascript and whack a half-hearted Material Design theme on there.