Hi,
I have a select query which is selecting all records in a table (which has around 8,000,000 rows in). "time" is a field of type "time". Should I be using <= and >= or BETWEEN to find records in a certain range? Which does MySQL optimise for? select time,price from csq where id = 12345 and date = now() and time >= '10:00' and time <= '11:00'; select time,price from csq where id = 12345 and date = now() and time between '10:00' and '11:00'; Kind Regards, -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]