title: Android: Get entire column data
body: <p>Im trying to get the data of an entire column into a string array. My database contains two columns Id and Names. I want to read all the entries of the names column and put it into a array. Please help.</p>
  
  <p>EDIT #1:
  Im using the following code but i can get only one name with this code.</p>
  
  <pre><code>String query = "Select * FROM " + TABLE_APPS + " WHERE " + COLUMN_NAME + " =  \"" + productname + "\"";
  
          SQLiteDatabase db = this.getWritableDatabase();
  
          Cursor cursor = db.rawQuery(query, null);
  
          if (cursor.moveToFirst()) {
              cursor.moveToFirst();
              name = cursor.getString(1);
              cursor.close();
          } else {
              name = null;
          }
              db.close();
  </code></pre>