title: MYSQL query select column string date compared to date formatted current date
body: <p>This is the query that I'm trying to run in my SQL phpMyAdmin to retrieve 2 rows of data:</p>
  
  <pre><code>SELECT * FROM table WHERE STR_TO_DATE(theDate, '%a, %b %e') = DATE_FORMAT(curdate(), '%a, %b %e')
  </code></pre>
  
  <p>I get no errors, also no results.  The format of the string in theDate column is like this for today's date:</p>
  
  <pre><code>Tue, Jan 20
  </code></pre>
  
  <p>What am I doing wrong in the conversions comparison?</p>