Filter MySQL results by todays date

probably so easy I will get flamed for this!

[delboy1978uk]

OK - Here's the setup:

Dreamweaver Site
MySQL Database
JSP Pages (irrellevent to this question)

Question:

I have a load of info in a database, each row has a TIMESTAMP.

I wish to have a page that displays the items added to the database for THAT DAY ONLY.

I think it should be something like
SELECT * FROM whatever WHERE datefield = NOW()
but I am a noob @ MySQL, and the above statement didn't work

Cheers Everyone willing 2 help :-)

[coopster]

You only want the DATE portion of the timestamp for comparison.

SELECT * FROM whatever WHERE DATE(datefield) = CURDATE();