title: Retrive the rows for a same date in mysql
body: <p>I want all the rows between two dates. I tried <strong>between</strong> but it doesn't show value for same date i.e., 2013-01-01 to 2013-01-01. In this case the result is null. But if i give dates like 2013-01-01 to 2013-01-02. It shows 10 rows for the 2013-01-01 whole day. Any ideas guys how to solve this in MySQL. My query is like this</p>
  
  <pre><code>SELECT MONTHNAME(access_date) as date,
         DATE_FORMAT( access_date,'%d/%m/%Y') as month_date ,
         COUNT( log_id ) as total_count
  FROM user_activity_log 
  WHERE dam_id =
           (SELECT dam_id FROM dam_content_details
                   WHERE content_type= 'userLogin') AND
                   access_date &gt;= '2013-01-03' AND
                   access_date &lt;= '2013-01-03'
                  GROUP BY MONTH( access_date ) 
                  ORDER BY access_date ASC 
  </code></pre>