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.