title: Mysql wildcard query problem
body: <pre><code>WHERE `time` BETWEEN 'Jan 1 %' AND 'Jan 8 %' AND ...
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>Jan 1 00:33:23
  Jan 10 08:52:05
  </code></pre>
  
  <p>How would I avoid the Jan 10 results?</p>
  
  <p>I have tried a few different combination with %, &lt;=, etc.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>