title: Return all rows which are same day in MySQL
body: <p>I store a date in my database as a string like this:</p>
  
  <p>03/08/2013  --> 8th of march</p>
  
  <p>I'm trying to select only the rows that are the same day as the current day:</p>
  
  <pre><code>SELECT * FROM wp_aerezona_booking WHERE DATE_SUB(CURDATE(),INTERVAL 1
                                           DAY) &lt;= STR_TO_DATE(date, '%m/%d/%Y')
  </code></pre>
  
  <p>The above is what I tried, but it is returning a lot of results and should only return 1.</p>