News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

OneNextraPixel.com:
13 Useful WordPress SQL Queries You Wish You Knew Earlier
February 01, 2010 @ 13:02:55

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).

0 comments voice your opinion now!
wordpress tutorial sql query useful


blog comments powered by Disqus

Similar Posts

DevChix: Getting started with YUI's Connection Manager in Rails and PHP

NETTUTS.com: 20 Steps to a Flexible and Secure WordPress Installation

Richard Thomas: Solar Gets Firephp Support & a Base Controller Tip

Shantanu Goel's Blog: Migrating From PHP4 To PHP5: Solving WP-Cache (and maybe other) Issues

Charlie Key's Blog: Transmitting data between Flex and PHP using JSON


Community Events





Don't see your event here?
Let us know!


opinion code list podcast install community language laravel framework unittest testing threedevsandamaybe configure refactor interview series developer release symfony2 introduction

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework