title: MySQL selecting time period
body: <p>I have a table called <code>away</code> with the following fields</p>
  
  <pre><code>+---------------+-----------------+---------------+
  | Name          |  from           |   to          |
  +---------------+-----------------+---------------+
  | Lee           |  12-09-11       |   16-09-11    |
  |               |                 |               |
  | Mike          |  10-10-11       |   12-11-11    |
  +---------------+-----------------+---------------+
  </code></pre>
  
  <p>What I need is a query to check if a person is away on a given day. For example <code>Lee</code> would be away on the 14-09-11 so I don't want to return this row.</p>