MySQL and RSS document

[cms9651]

Hi there.

My problem today is this statement.

     SELECT * FROM tblRSS
     WHERE DATEINSERT >= CURRENT_DATE - INTERVAL 2 DAY 
     ORDER BY MONTH(DATEINSERT) DESC, RAND() LIMIT 0, 1

The `tblRSS` is populate with an RSS document and statement publish random record.

But today strange import for the RSS document where `DATEINSERT`=2012-03-29 and the statement extract only this row where `DATEINSERT`=2012-03-29.
The manual intervention resolves this anomaly....

How to avoid future problems ?
I hope your help.

[r937]

CURRENT_DATE - INTERVAL 2 DAY would be 2012-03-04

2012-03-29 is greater than 2012-03-04

what was your question again?

[cms9651]

I'd appreciate your help so very much.

My question: is possible to prevent this problem with my statement in mysql ?

I don't not if the RSS document it's wrong ( 2012-03-29 ) in the `DATEINSERT`...