WordPress users out there might want to check out this list of SQL queries that could help you solve that problem you've been working on.
WordPress is driven by a MySQL database. This is something active WordPress users would know. However, if you only just read about it here from us, here's what you should know. [...] By simply executing a SQL query against your WordPress database, you can make the necessary changes quickly and efficiently.
The SQL queries cover a wide range of the popular blogging tool's features including:
- Change the Siteurl & Homeurl
- Change a URL in Content
- Change an Image Path Only
- Resetting Password
- Export all Comment Emails with no Duplicate
They also recommend you backup your database before executing any of these statements...just in case (instructions are included for that too).