How to get data for today, yesterday, the day before yesterday... day?

Question

MySQL

How to get data for, for example, only yesterday?

My date is stored in Y-m-d H:i:s.
Try this, but I get nothing in response:

SELECT * FROM `payments` WHERE `date` = DATE_SUB(NOW(), INTERVAL 1 DAY)

Answer 1

There must be a date range condition

SELECT * 
FROM `payments` 
WHERE `date` BETWEEN DATE(DATE_SUB(NOW(), INTERVAL 1 DAY)) AND DATE(NOW());