Snipplr

(MySQL) MySQL Time Ago function - Jamie

Sat, 16 Jun 2012 00:56:15 UTC

Retrieves a relative time in a MySQL Query

(MySQL) Save a MySQL Query as a Tab or Comma separated file - Jamie

Tue, 16 Aug 2011 01:16:00 UTC

Simple example of how you can output a query as

(MySQL) Find All SlideDeck Slides from the wp_posts Table - Jamie

Tue, 14 Dec 2010 12:15:33 UTC

This SQL query will find all the SlideDeck related entries in your WordPress database.

(MySQL) MySQL Join on NOT Condition - Jamie

Fri, 12 Nov 2010 10:31:26 UTC

This was a strange case where I had to select all the items that were NOT assigned to a user. The data structure assumes that there is a 1 to 1 relationship between a user and an item. This is a simplified version of the query, but it's one of those queries that takes a while to figure out.

(MySQL) Move Column in MySQL Table - Jamie

Fri, 09 Jul 2010 08:17:57 UTC

(MySQL) MySQL Find and Replace - Jamie

Thu, 25 Feb 2010 12:50:05 UTC

This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.