How do you issue SELECT to select items posted in last X seconds?

Databases
1

Hello,

How do you issue SELECT to select items posted in last X seconds?
For example for last 60 Seconds.
I have tried this:

SELECT * FROM xyz
WHERE ip = ‘$ip’
AND date_added > (DATE_SUB(CURDATE(), INTERVAL 60 SECOND))
ORDER BY id DESC;

But this does not return correct results as the list that it returns is not limited to last 60 Seconds but more like 20 Hours or so!!!

Thanks.

2

Please ignore this Question.
I found the answer to it already.

3

what was it? because that sql looks okay to me