title: MySQL selecting yesterday's date
body: <p>How can I display and count the values whose dates are yesterday?
  I used <code>time()</code> to insert date in the database. Example:</p>
  
  <pre><code>URL: google.com youtube.com google.com youtube.com test.com youtube.com
  DateVisited: 1313668492 1313668540 1313668571 13154314
  </code></pre>
  
  <p>I want do display how many URLs that have multiple existed in the table and also how many of that URL have been visited yesterday. Example result:</p>
  
  <pre><code>LINK       | timesExisted | timesVisitedYesterday
  Google.com |       2      | 2
  youtube.com|       3      | 3
  </code></pre>
  
  <p>I already have the idea on getting yesterday's date, but I don't have an idea on counting how many times a URL has existed for yesterday and counting how many times a URL has existed in the table.</p>