How to choose a column of data from 2 days ago?
If the current WHERE condition specifies today and you want yesterday, then just subtract one day from both expressions. That will make the first expression CURDATE() - INTERVAL 1 DAY and the second simply CURDATE():

SELECT column1 
FROM db.table 
WHERE TS &gt;= CURDATE() - INTERVAL 1 DAY AND TS &lt; CURDATE();