[RESOLVED] select rows from the past 24hours (MySQL)

[jrolands]

I'm in need of a where clause that extracts rows posted within the last 24hours based on column - "timestamp"
Any suggestions?

[Scriptmaker]

Been reading up on mysql date functions. There's quite a few of them!

I found this posted on another forum that might be of some use:

  

      SELECT FROM table_name WHERE date_column < DATE_SUB( NOW(), INTERVAL 24 HOUR)

away from my home comp, so can't really test it for you.

Hope this helps.

[jrolands]

Thanks man.. 😃
It seems like it's working, still testing. although i had to change it from < to >..

[Scriptmaker]

Glad to hear it. Good luck with the rest of your script!