title: Get closest date from MySQL table
body: <p>I need to get the closest date to current date from a MySQL table.</p>
  
  <p>This is my table:</p>
  
  <pre><code>id        | date          | name
  1         | 2012-10-29    | test
  2         | 2009-11-31    | test
  </code></pre>
  
  <p>So if the query was run today, it would return <code>1         | 2012-10-29    | test</code></p>
  
  <p>Any help is much appreciated. Thanks</p>