sql - get 2 days ago query in mysql

Question

So for getting last 24 hours query I use something like this

SELECT COUNT(*) AS cnt FROM `mytable` WHERE timestamp >= DATE_SUB(NOW(), INTERVAL 1 DAY)

where timestamp is a table field with timestamps.

but how can I get the interval between 2 days ago and yesterday. So

today is 24 ian. I want a query between 22 ian (00:00am) and 23 ian (00:00am)

Answer 1

WHERE timestamp BETWEEN 
        DATE_SUB(DATE(NOW()), INTERVAL 2 DAY)
         AND DATE_SUB(DATE(NOW()), INTERVAL 1 DAY)