title: MySQL check whether current date time is between 2 fields date and time
body: <p>In MySQL how we can check the current date and time is between the 2 fields which are stored with the start date time and end date time, i have tried like below, but it doesn't return any record and the code is below</p>
  
  <pre><code>SELECT * 
  FROM tbl_user_rig_rentals 
  WHERE (NOW( ) BETWEEN amount_paid_date AND mining_end_date)
  </code></pre>
  
  <p>where <code>amount_paid_date</code> is <code>2014-07-09 12:53:26</code> and <code>mining_end_date</code> is <code>2014-07-09 03:30:26</code></p>