Some Useful WordPress MySQL Queries

By Prem Tiwari in Mysql, WordPress, WordPress Snippets. Updated on


This is a very quick tutorial about some useful WordPress MySQL queries. In this tutorial, I will share some useful MySQL queries which will help you when you are going to move your WordPress site from your dev, staging server to production server.

When you upload any WordPress site from staging server to production server, then you need to replace the staging URLs from your application with production URLs.

wordpress mysql tutorial

Some Useful WordPress MySQL Queries

Below are the lists of some MySQL queries which replace your old URLs to new URLs in your website’s database tables. Copy the below MySQL queries and execute it in SQL tab of your PHPMyAdmin or you can use any MySQL client software like MySQL workbench.

Sharing is caring!


Prem Tiwari

An engineer by profession and a passionate blogger by heart. Founder of FreeWebMentor.com (A Programming blog for beginners), Tech Speaker at various forums. A part from this he is an open source enthusiast, WordPress Lover, Blogger, SEO, and Growth Strategic.

You might also like:

Tags: , , , , , , ,

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.