title: How to Filter Data within Date Range with Searched Data?
body: <p>I have fetched data within date range.</p>
  <pre><code>query = &quot;SELECT * FROM table WHERE (date BETWEEN '2020-01-01' AND '2020-12-31')&quot;;
  </code></pre>
  <p>Its working well shows data between dates but when I search perticular data within date range it is showing all matched records outside date range.</p>
  <pre><code>query = &quot;SELECT * FROM table WHERE (date BETWEEN '2020-01-01' AND '2020-12-31') AND ID LIKE '%dhaval%' OR firstname LIKE '%dhaval%' OR lastname LIKE '%dhaval%' &quot;;
  </code></pre>
  <p>Above query searches all data named dhaval in entire table.</p>
  <p>I want searched data within date range how can I do this ?</p>