[jeremyk]

I need to look up any entries for a given user in the last day, note not 24 hours. I tried using DATE_SUB but keep getting no results even though there is date. The field in question is a datetime field and was created using NOW() during the record insert.

Thanks in advance.

[r937]

WHERE field_in_question >= CURRENT_DATE - INTERVAL 1 DAY
  AND field_in_question  < CURRENT_DATE