Re: Optimizing nullable expiration dates

2008-11-17 Thread Real Estate
Hi, I am getting copies of your email...I don't know why...Can you fix this problem.. Kind regards, Matthew - Original Message - From: "Mark Goodge" <[EMAIL PROTECTED]> To: "mysql" Sent: Monday, November 17, 2008 10:14 AM Subject: Re: Optim

Re: Optimizing nullable expiration dates

2008-11-17 Thread Mark Goodge
Norman Elton wrote: I've got a table that tracks expiration dates. Currently, if the record hasn't expired, the column is stored as NULL. In order to find records that haven't expired, I search for "WHERE expire_at > NOW() OR expire_at IS NULL". This seems dirty, and I suspect it makes my index