Snipplr

(MySQL) MySQL Find and Replace - Jamie

Thu, 25 Feb 2010 12:50:05 GMT

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

(MySQL) Selecting a Random Row In MySQL - jordantbro

Wed, 21 Jan 2009 16:26:22 GMT

(MySQL) Create CSV from MySQL - matula

Fri, 17 Sep 2010 08:23:23 GMT

(MySQL) Find duplicate records - fugue

Wed, 05 May 2010 10:18:29 GMT

(MySQL) Correcting wrong character encoding in MySQL data - jdbartlett

Fri, 06 Mar 2009 21:30:47 GMT

When you forget to "SET NAMES utf8", you'll probably end up with a bunch of latin1 data in your utf8 column. This query fixes that, CONVERTing the existing data to its correct collation.

(MySQL) Load CSV back into mySQL - matula

Fri, 17 Sep 2010 08:25:51 GMT

(MySQL) Drupal 6.x Find PHP code in database - ReeceMarsland

Fri, 04 Dec 2009 05:51:03 GMT

(MySQL) Generate random string in MySQL - fugue

Tue, 10 Nov 2009 04:43:58 GMT

(MySQL) Calculate Age from Date Of Birth - nkm

Sat, 29 Aug 2009 17:15:04 GMT

It's not 100% accurate, but works fine for people under 1.480.

(MySQL) Find & Replace - randyjhunt

Sat, 16 May 2009 15:11:27 GMT

(MySQL) Select between two dates - craig1709

Sun, 26 Apr 2009 10:15:38 GMT

(MySQL) how to calculate last 7 days... - craig1709

Thu, 08 Jan 2009 14:17:36 GMT

if you want to get info from a column within certain date, like the latest 7 days, you should use this, mydatefld is your date column

(MySQL) US & CANADA Cities Database - frederichoule

Sat, 22 Oct 2011 12:36:31 GMT

(MySQL) mysql dump - elguapo1611

Wed, 01 Dec 2010 02:31:24 GMT

(MySQL) Mysql replace - mikael12

Thu, 14 Oct 2010 21:06:34 GMT

(MySQL) Convert timezone to local - fugue

Wed, 10 Mar 2010 03:19:40 GMT

Converts a date or time from one timezone to another.

(MySQL) Search and Replace on Multiple Rows in SQL - Tate

Thu, 25 Feb 2010 11:20:49 GMT

(MySQL) multiple insert with one query - renaars

Wed, 20 Jan 2010 17:11:36 GMT

(MySQL) How to Save results from MySQL into an external file - endorfin

Fri, 18 Dec 2009 10:41:50 GMT

(MySQL) Insert or update if unique key already exist - Zwendel

Tue, 27 Oct 2009 10:42:59 GMT

(MySQL) mySQL - database backup commands - stiobhart

Sun, 07 Jun 2009 11:23:02 GMT

CLI commands for backing up mySQL database

(MySQL) Backup MySQL Database to SQL File with mysqldump - cbrant

Fri, 10 Apr 2009 04:52:08 GMT

(MySQL) MySql import - glends

Fri, 10 Apr 2009 04:28:09 GMT

(MySQL) find duplicate records - wirenaught

Sat, 23 Apr 2011 00:33:23 GMT

(MySQL) MySQL Find and Replace - nielsenrc

Wed, 02 Mar 2011 06:39:40 GMT