如何在指定的时间戳后获取所有时间戳？

Question

I am making a chat program and I want to find all timestamps that are greater than a timestamp in a mysql query. I currently have this query

SELECT Message, SendTime, Sender FROM ChatMessages WHERE ((Recipient=$me AND Sender=$talkTo) OR (Sender=$me AND Recipient=$talkTo)) AND 

I am making it check for new chat messages and I want my query only to return new ones. I have a timestamp of when I last checked for messages.

Answer 1

You can put this:

SendTime > yourTime

at the end of your AND condition to produce the desired result.