Mysql从表中删除日期为'昨天'但忽略时间戳

I have a table in Mysql which has column called 'dep_timestamp' which holds data in the following format (the data is received from a external source so can't be changed, and is displayed via web queries so can't be modified within that table)I have a table in Mysql which has column called