title: How do I make a case insensitive query with ContentResolver in Android?
body: <p>My goal is to get all rows from native db with a specific email address on Android Gingerbread and above.</p>
  
  <p>This query gets only the rows where the case also matches.</p>
  
  <pre><code>Cursor cursor = context.getContentResolver().query(ContactsContract.CommonDataKinds.Email.CONTENT_URI,
              new String[] {Contacts._ID}, ContactsContract.CommonDataKinds.Email.ADDRESS + "=?",
              new String[] {email}, null);
  </code></pre>
  
  <p>I've read about WHERE clauses to sql where one use lower('xx') but I can't figure out how to use it. Also I learned to you can make the column not care about case when creating the table, but that ship has sailed.</p>