title: SQLite Query : Select Query with BETWEEN clause
body: <p>I want to run this query in Android Application :  </p>
  
  <pre><code>SELECT field1 FROM table1  
  where field1 = ?(enteredField1) AND field2 = ?(enteredField2)  
  AND enteredField3 BETWEEN field3 , field4  
  ;
  </code></pre>
  
  <p>my DB schema  </p>
  
  <pre><code>table1(field1, field2, field3, field4, field5)  
  </code></pre>
  
  <p>enteredField1 , 2 , 3 = are parameters which is to be checked.</p>
  
  <p>I hope I am clear with my question.  </p>
  
  <p>here is the function -  </p>
  
  <pre><code>public boolean checkData(String task1, String dte1, String startTime1 )  
  {   
  
          // field 1 = task , fiels 2 = dte, field 3 = startHr, field 4 = endHr  
          // enteredField 1,2,3 = task1, dte1, startTime1   
          // here I want to insert the query  
  
      int a = cursor.getCount();  
      if(a&gt;0)  
      {  
          return true;  
      }  
      return false;  
  }  
  </code></pre>