Index and date functions

[Aurelien PANIZZA]

Hi,

I'm using MySQL 5.0.96 and I try to use an index defined on a date type column with a date function. Below is a example of what my query looks like :

SELECT * FROM my_table WHERE date_col > sysdate() - INTERVAL 30 DAYS;

date_col is defined as "date" type.
I want to retrieve all rows which have a date_col not older than 30 days from the current date.

My problem is that I can't have the query use the index defined on the column date_col. The query always do a full scan on the table. Is there any way to have the query use the index when using a date function ?

regards



Edited 1 time(s). Last edit at 01/30/2013 11:28AM by Aurelien PANIZZA.