title: MYSQL query: select between date with local format
body: <p>my mysql database tb_date (varchar 20):</p>
  
  <ul>
  <li>16 November 2014</li>
  <li>06 December 2014</li>
  <li>01 April 2014</li>
  <li>12 April 2015</li>
  </ul>
  
  <p>I want select between 01 January 2014 until 31 December 2014, how the query is with date conversion?</p>
  
  <p>thanks..</p>