Select previous day timestamp

[jtelo]

I have a table with the columns code, user and date (in the timestamp format. Example: 2010-07-09 11:23:42).

 

I'm trying to make a query with PHP and mySQL to return the rows with the timestamp of the previous day, but can't make it work.

 

Can someone please help me?

[Topshed]

I am no expert but as the time stamp in a number of units sine inception I would have thought using now() and minus the figure for 24 hours would do the job ??

 

Just a thought

Topshed

[jtelo]

I am no expert but as the time stamp in a number of units sine inception I would have thought using now() and minus the figure for 24 hours would do the job ??

 

Just a thought

Topshed

 

With this i get all the rows of the previous days, but can't make it return only one day:

SELECT * FROM table WHERE date<NOW()

[PFMaBiSmAd]

SELECT * FROM table WHERE DATE(date) = CURDATE() - INTERVAL 1 day

[jtelo]

SELECT * FROM table WHERE DATE(date) = CURDATE() - INTERVAL 1 day

 

Thank you all for the help. I got what i wanted with this:

select * from table where `date` BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND CURDATE()