Querying yesterday

MySQL

[RussellC]

I have been trying to figure out how to query for yesterday.

I have a table that has a DATETIME type. How can I SELECT all of the items from the table that occured yesterday. For some reason I can't figure it out. I know that NOW() - 1000000 will give me the time right now yesterday, but i need all times for the previous day.
If anyone can help it would be much appreciated. Thanks.

[DrDoc]

6.3.4 Date and Time functions [mysql.com]

[Birdman]

Hello Russel,

How about this method?

SELECT *
FROM table
WHERE time
LIKE '20030313%'

[RussellC]

Thanks Birdman, but I meant 'Yesterday' dynamically. I figured it out though.

SELECT widget FROM widgets WHERE date = DATE_SUB(CURDATE(), INTERVAL 1 DAY);

Thanks all,