title: MySQL: Alternative to ORDER BY something LIMIT 0,1
body: <p>Is there a better way to do this?</p>
  
  <pre><code>SELECT * FROM mytable WHERE column=something ORDER BY date LIMIT 0,1;
  </code></pre>
  
  <p><strong>EDIT</strong>:I have a table with columbs: <code>ID Name Date</code>.  I want to get the most recent entry (using the date column) where Name is Bob.  </p>