Compare Date

[Tay Geok Lin]

Hi all

I want to ask how can i compare current date and the date i store in the database for my food?

eg. if i have a rice which expire in 4 days and a spaghetti that is going to expire in 2 days. I want it to display the one that expire in 2 days.

this is my query.
SELECT b.title FROM books b, avaliable a, ingredient i
where datediff(STR_TO_DATE(b.expiry, '%d-%b -%Y') , now()) Between 0 and 6
and b.book_id = a.book_id and a.Int_ID = i.Int_ID