title: How to query between dates and those with null?
body: <pre><code>Select area, book, sequence, accountnumber, name, address, polenumber from master
  where newconnectiondate is null
    and newconnectiondate between '1950-01-01' and '2015-10-31'
  </code></pre>
  
  <p>This is my query in mysql. But it all do wrong. I want to query data using between date but it doesnt query those with null date and now I want to query between date and with null date</p>