Whats wrong with this date query

[gevensen]

Im looking to search back 90 days for example but it only returns say the last 2 weeks, if i increase it i see other records but still not the full number

any ideas?

 

SELECT * FROM sc_income WHERE full_name = 'Smith, John' AND date >= CURRENT_DATE - '90'

[cags]

I'm guessing that '90' has no quantifiable meaning to MySQL. Minus 90 what? hours, days, months?

[bowett]

You could always try:

 

SELECT * FROM sc_income WHERE full_name = 'Smith, John' AND date >= DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY)

 

Should have the desired effect but not tested it.

[Barand]

Alternatively,

 

SELECT * FROM sc_income WHERE full_name = 'Smith, John' AND date >= CURDATE() - INTERVAL 90 DAY

 

[gevensen]

ok repeat after me DOYYYYYYYYYY

 

i had the query right originally but used 90 DAYS instead of 90 DAY

 

It didnt work with days do i came up with the next query which i posted

 

thanks for the help