title: Find closest datetime to specified datetime in mysql query
body: <p>I am trying to find a datetime value in a mysql database that is the closest match to a datetime that i specify, i am having some trouble.</p>
  
  <p>The following pseudo code is what i want to achieve:</p>
  
  <pre><code>SELECT one FROM table WHERE datetimefield is closest to "2014-12-10 09:45:00" LIMIT 1
  </code></pre>