title: Android Searching Database with Empty Where Clause
body: <p>I am trying to do a search function in android that will allow the user search with different filters. I am able to create a simple <code>select</code> statement with multiple <code>where</code> clauses. My issue arises when the user doesnt use the filter options, is there a way to continue the select statement but use blank values in the <code>where</code> clause?</p>
  
  <p>For example, the user will want to search for all the cars and add a filter looking for specific green cars made in the year 2011.</p>
  
  <pre><code>"Select * from cars where colour = 'green' AND year = 2011"
  </code></pre>
  
  <p>Example where the user searches without filters for all cars</p>
  
  <pre><code>"Select * from cars where colour = '' AND year = "
  </code></pre>
  
  <p>I dont want to have to use two statements I would just like to use the one and have blanks in the <code>where</code> clause is nothing is selected in the filter, is this possible?</p>