MySql

This is an sql method for joining two rows in the same table. I have a table that stores emails in two parts, the name and the domain. The data is stored in the same column, but in subsequent rows. So row 1 is value = 'adam' and row 2 is value = 'hyperspatial.com'

I needed to count up all the ... View Code

joins

Ordering sql results randomly using the ORDER BY RAND() clause/function can be slow with huge tables. This snippet basically selects the rows before randomization instead of randomizing the whole table every time.

Just add the first snippet after your WHERE clause and any AND's, otherwise it ... View Code

tricks

This snippet allows you to combine two table updates with one trip to the DB in a single query
View Code

multiple, mysql, tables, update

This will update a time field and add time to a field View Code

add, msyql, time

This is a list of reserved MySql words. You cannot use these terms in your query with the exception of the actual command. View Code

help