Mysql Previous 24 Hours excluding latest 24 hours

Asked May 13 '15 at 15:57

Active May 13 '15 at 15:57

Viewed 33 times

I am trying to figure out how to select the previous 24 hours to run a cron job email notification. Basically, I want to check for which staff has not responded within 24 hours of the time the record was created. Any help would be appreciated.

SELECT * FROM `eventstaff` WHERE created >= DATE_SUB(NOW(), INTERVAL 1 DAY) AND status = "noresponse"

So for example

status     staffname  created               jobid
noresponse johndoe    2015-05-12 10:38:36   546
noresponse janesmith  2015-05-13 08:42:27   287

If I ran that query now at 10:58 on 5-13 it would skip janesmith and get johndoe. The janesmith would continue to be ignored until 8:42:27 on 5-14.

asked May 13 '15 at 15:57

NUGGET

http://stackoverflow.com/questions/3822648/how-do-i-query-between-two-dates-using-mysql – anonymous May 13 '15 at 16:01
don't you just need to reverse the where clause, using `<`? – guido May 13 '15 at 16:02
I'm an idiot, that did the trick. Been looking at code to long I guess. – NUGGET May 13 '15 at 16:05

Mysql Previous 24 Hours excluding latest 24 hours

0 Answers0