mysql

How to Find & Replace Data in MySQL
WordPress Serialized PHP Search Replace Tool | Interconnect IT – WordPress Consultants, Web Development and Web Design
How to get rank using mysql query | Thinkdiff.net

This was exactly what I needed to rank a large dataset. So happy to have found it!

Particletree » To Insert or To Update

I’m digging the ON DUPLICATE KEY UPDATE command. Seems like a better solution for the INSERT or UPDATE dilemma.

MySQL Lists: mysql: RE: SQL : convert string to integer

This tip came in very handy when trying to sort by a custom field in WordPress (I’m storing numerical values, but the field is varchar).

My Great Data (migratedata)

This seems like a sensible way to convert blogs and other CMSs. I do that from time to time so I’ll probably release some customizations as I create them.

mysql backup tutorial using mysqldump

A nice, succinct guide to dumping and reading SQL data from MySQL.