我想从表中检索所有记录，这些记录是使用php mysql在24小时后发布的

I want to retrieve all the records from a table which were posted 24 hours back using php mysql. I can able to get last 24 hour inserted records using datetime column. But i want the records which were inserted into table and completed 24 hours from posting.

Please guys help me out!

Assuming that "date" is your datetime column and "mytable" is your table

SELECT * FROM mytable WHERE date <= DATE_SUB(NOW(), INTERVAL 24 HOUR)