title: Retrieve multiple rows from sqlite using where clause Android
body: <p>When I try to retrieve multiple rows from SQLite by using the WHERE clause, I am getting only the first row... i.e.: <code>mCursor.getCount()</code> returns 1 always...<br>
  Is there any way to retrieve multiple rows from a table by using the WHERE clause?<br>
  This is what i have tried so far<img src="https://i.stack.imgur.com/fCqqF.png" alt="ScreenShot"></p>
  
  <pre><code>myPath = DB_PATH + DB_NAME;
      myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
      String query= "SELECT * FROM location where emirate='"+s+"'";
      Cursor mCursor = myDataBase.rawQuery(query, null);
      int i= mCursor.getCount();
      if (i&gt;0) {
             mCursor.moveToFirst();
             shoplist.add(mCursor.getString(1));
          }
          mCursor.close();
          myDataBase.close();
      }
  </code></pre>