2018-03-17 mysql mysql where yesterday by curdate() WHERE offers.date >= CURDATE() - INTERVAL 1 day Grab where CURDATE() and the day before with MySQL Newer bigflow top one field Older python sum the columns in 2D list