Question: I am very much new to database & trying to pull values based on regions. My table already have region (draft\_region\_name) column. Below is my code

```
    SQLiteDatabase db = this.getWritableDatabase();

    String where = "";
    for (int i = 0; i < names.size(); i++) {
        where = where + KEY_DRAFT_REGION_NAME + " = " + names.get(i).toString() + "";
        if (i != (names.size() - 1))
            where = where + " or ";
    }

    Cursor cursor = db.query(TABLE_DRAFT_TABLE, null, where, null, null, null, null);

```

I am getting this expection

```
android.database.sqlite.SQLiteException: no such column: AHMEDABAD (code 1): , while compiling: SELECT * FROM DraftTable WHERE draft_region_name = AHMEDABAD

```

Answer: 
```
PLAYERS.set(index, ("char1", variable, variable));

```

Is not valid Java syntax. You most likely mean

```
PLAYERS.set(index, new PLAYER("char1", variable, variable));

```

Also, please adhere to standard Java naming conventions: `PLAYERS` should be `players`.
Your ArrayList **doesn't** contain multiple data types. It holds objects of Player and only Player type, and you appear to be trying to over-complicate things. You simply get your Player from the ArrayList and then modify it.

```
Player p = players.get(i);
p.setName("foo");
p.setMoney(50);

```