title: MySQL query by age range on a table which have date of birth
body: <p>I have MySQL table with a date of birth. And I want to query the rows which based on age for current date. So following is the query for the table with date range.</p>
  
  <pre><code>SELECT * FROM `user` WHERE `dob` &gt; '1980-01-20' AND `dob` &lt; '1990-01-20';
  </code></pre>
  
  <p>How can we convert this query to search with age range for the current date in the same table?</p>