Select all data for the last 5 days

Question

In mysql, I need to get all the last 5 days of records. Therefore if i have

Name       date
aaaa      20/11/2010
dddd*      24/11/2010*
bbbb      22/11/2010
cccc      23/11/2010
eeee*     25/11/2010*
ffff*      26/11/2010*

I need only the last 5 days.

I tried something like:

SELECT name,date 
from Lineas
WHERE date >= DATE_SUB(CURDATE(), INTERVAL 5 DAY)
ORDER BY date DESC

but it does not work.

Answer 1

If the problem is “recordings from the future,” you just need to limit your results a bit than you already did:

SELECT name,date 
from Lineas
WHERE date >= DATE_SUB(CURDATE(), INTERVAL 5 DAY) AND date <= CURDATE()
ORDER BY date DESC

Answer 2

Have you tried between

SELECT  name,
        date  
from    Lineas 
WHERE   date BETWEEN DATE_SUB(CURDATE(), INTERVAL 5 DAY) AND CURDATE()
ORDER BY date DESC