title: between in two columns not working properly
body: <p>I have one table <code>events</code></p>
  
  <p>using this table i have to get the records between two dates and two columns in mysql,see below i mentioned my table format</p>
  
  <pre><code>eventId          startDate            dueDate
  
   1                2018-01-15          2018-01-17  
   2                2018-01-25          2018-01-25
   3                2018-01-11          2018-01-16
  </code></pre>
  
  <p>Suppose i want to take the records from <code>2018-01-14</code> into <code>2018-01-16</code> means actual results should come like below</p>
  
  <blockquote>
    <p>My Expected answer</p>
  </blockquote>
  
  <pre><code>eventId
   1
   3
  </code></pre>
  
  <blockquote>
    <p>I tried like this but nothing is coming</p>
  </blockquote>
  
  <pre><code> SELECT eventId FROM events WHERE startDate &lt;= '2018-01-30' AND DueDate &lt;= '2018-01-30'
  </code></pre>
  
  <blockquote>
    <p>I am getting output</p>
  </blockquote>
  
  <pre><code>eventId
   3
  </code></pre>