George Law wrote:
This brings up a question I was asked...Which is more efficient? Select ..... where date between 'yyyy-mm-dd hh:mm:ss' and 'yyyy-mm-dd hh:mm:ss'
This one.
Or Select ..... where unix_timestamp(date) between unix_timestamp('yyyy-mm-dd hh:mm:ss') and unix_timestamp('yyyy-mm-dd hh:mm:ss')
This one cannot use an index.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]