MySQL and RSS document

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.

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

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

what was your question again?

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