title: MySQL: How to ask for a date greater than today when a date is in a string
body: <p>I'm try to extract info from a MySQL DB into a MS SQL DB. The DB is a mess and the developer is no longer available.</p>
  
  <p>All dates are in char fields, and I use </p>
  
  <pre><code>SELECT concat( mid(DueDate, 7, 4), mid(DueDate, 4, 2), mid(DueDate, 1, 2)) as DueDate FROM TableName
  </code></pre>
  
  <p>to get the date field in a format so MS sql server can import them.</p>
  
  <p>Now, I want to export only the record with the date greater than today, so the questions are:</p>
  
  <ul>
  <li>What is the equivalent of GetDate() in MySQL?</li>
  <li>Is there a better way to cast the date to make the comparison?</li>
  </ul>