mysql - 计算前一天的日期

Question

我试图总结表中字段的值，但是条件之一是日期必须是前一天的，我尝试使用 sql curdate() 但到目前为止我无法获取它上类:

string varsql = "SELECT  sum(merc1)/2 as total 
                 FROM  wgcdoccab 
                 where tipodoc ='FSS' 
                 and serie='1' 
                 and contribuinte='999999990' 
                 and SELECT DATE_ADD(CURDATE(), INTERVAL -1 DAY);"; //division query 

Answer 1

SELECT sum(merc1)/2 as total 
FROM wgcdoccab 
where tipodoc ='FSS' 
and serie='1' 
and contribuinte='999999990' 
and date_column = CURDATE() - INTERVAL 1 DAY