I have a table called `away` with the following fields

```
+---------------+-----------------+---------------+
| Name          |  from           |   to          |
+---------------+-----------------+---------------+
| Lee           |  12-09-11       |   16-09-11    |
|               |                 |               |
| Mike          |  10-10-11       |   12-11-11    |
+---------------+-----------------+---------------+

```

What I need is a query to check if a person is away on a given day. For example `Lee` would be away on the 14-09-11 so I don't want to return this row.