title: get records of today, yesterday and this week
body: <p>I want to show records of today (from yesterday 12 AM to today 11:59 PM), Yesterday, and records of this week, 
  I have this query for todays records</p>
  
  <pre><code>SELECT COUNT(*) FROM `tblpatients` WHERE `Is_Deleted` = '0' AND `TimeStamp` &lt;= NOW() AND `TimeStamp` &gt;= ?????
  </code></pre>
  
  <p>I have a field in my table named TimeStamp format is 2014-09-20 12:11:20</p>