select * from tabella where campo_data = curdate() - interval 1 day