title: how to search between two dates and restrict to a particular name
body: <p>I am creating a search form that is supposed to search between two dates for a particular users records.</p>
  
  <p>Presently, I can search between two dates using this sql statement</p>
  
  <pre><code>SELECT *
  FROM `project details` 
  WHERE `id`  BETWEEN colname AND colname2 
  </code></pre>
  
  <p>But, now I want to make this search restricted to a particular users record</p>
  
  <p>e.g selecting all records for "micheal" between two dates, lets say the column for users was called "username"</p>
  
  <p>How should i edit my SQL statement to achieve such result?</p>
  
  <p>Regards</p>