title: selection of future date records from mysql database table
body: <p><img src="https://i.stack.imgur.com/U31CW.png" alt="enter image description here"></p>
  
  <p>Architecture of my table is as following:</p>
  
  <p><img src="https://i.stack.imgur.com/B6Rot.png" alt="enter image description here"></p>
  
  <p>I have the above table, wherein date datatype filed "l_from", i want to select all those records which having today date or all the future date from now.</p>
  
  <p>For this i have used the following queries:</p>
  
  <pre><code>SELECT emp_sno,emp_type,l_from,l_to,l_nature 
  FROM leaves_history 
  WHERE l_from &lt; CURDATE() AND emp_type = 1
  </code></pre>
  
  <p>But the above query does not help.<br>
  I have changed the </p>
  
  <pre><code>where l_from &gt;= curdate()
  
  where l_from &lt;= curdate() 
  </code></pre>
  
  <p>but in no clause return the highlighted row.</p>
  
  <p>What should i have to change in?</p>
  
  <p>thanks in advance</p>