title: select distinct value in android sqlite
body: <p>I try to run the following raw query in android, it seems not work</p>
  
  <pre><code>String query ="SELECT DISTINCT category FROM event";
  Cursor  cursor = mDb.rawQuery(query, null);
  if (cursor != null) {
       cursor.moveToFirst();
  }
  return cursor; 
  </code></pre>
  
  <p>so I decide to use the query() method in android which are something like</p>
  
  <pre><code>Cursor mCursor = mDb.query(EVENT_TABLE, new String[] {KEY_ROWID, KEY_CAT}, null, null,null,null, null)
  </code></pre>
  
  <p>Can anyone show me how to select the distinct category for using query() instead of rawquery please, any help will be greatly appreciated!</p>