SQL Retrieve Or Count Record On A Previous Date In MySQL

Here's a simple demonstration of sql in MySQL where you can retrieve a record from a previous date.

  select sum(data_gathered) as data_gatherer,   
      name from tblctivity  
       where name like '%prgGatherer1.xml%'  
         and (date(rec_date) = (CURDATE() - 1));