How to retrieve specific data from particular column?

Question

My app has an SQLite table with columns id, category and item_name. category is of type string. Primary key is id. I want to retrieve names of all items in category Veg then display this in list view. I tried following queries :

String vg ="Veg"; Cursor mCursor = database.query(true, DATABASE_TABLE, new String[] { KEY_ROWID, KEY_CATEGORY, KEY_NAME,KEY_PRIZE,KEY_DESCRIPTION }, KEY_CATEGORY + "=" + vg , null, null, null,null, null); if (mCursor != null) { mCursor.moveToFirst(); } return mCursor;

Query:

String query = "SELECT * FROM todo WHERE category =" + vg ; Cursor cursor = database.rawQuery(query,null); if (cursor != null) { cursor.moveToFirst(); } return cursor;

stackoverflow.com/questions/6653502/… stackoverflow.com/questions/5974799/… — Samir Mangroliya
– Samir Mangroliya, Commented Sep 12, 2011 at 12:01

Steve2955 · Accepted Answer · 2016-12-30 18:28:20Z

18

try this:

String query = "SELECT * FROM todo WHERE category='" + vg; Cursor cursor = database.rawQuery(query,null); if (cursor != null) { cursor.moveToFirst(); } return cursor;

edited Dec 30, 2016 at 18:28

Steve2955

6901 gold badge6 silver badges18 bronze badges

answered Sep 12, 2011 at 12:04

Lavanya

3,9136 gold badges33 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sagar Over a year ago

Thanks, this also working. ' was missing after "=" from my query.

Tushar Vengurlekar · Accepted Answer · 2011-09-12 12:29:00Z

String query = "SELECT item_name FROM todo WHERE category =" + vg ; Cursor cursor = database.rawQuery(query,null); if (cursor.moveToFirst()) { while (cursor.isAfterLast() != true) { string itemname = cursor.getString(cursor.getColumnIndex("item_name"))); } }

Here moveToFirst checks if there are items satisfying the criteria and then loops through cursor using while loop. The string itemname can be replaced by list adaper to populate the data. Hope this helps.

Manikanta Reddy · Accepted Answer · 2016-04-12 09:43:46Z

dbHelper = new DBHelper(getApplicationContext()); SQLiteDatabase db = dbHelper.getReadableDatabase(); Cursor cursor = db.rawQuery("select * from centuaryTbl where email='"+email+"'",null); if (cursor.moveToFirst()) { do { String s1 = cursor.getString(cursor.getColumnIndex("s1")); String s2 = cursor.getString(cursor.getColumnIndex("s2")); String s3 = cursor.getString(cursor.getColumnIndex("s3")); }while (cursor.moveToNext()); }

PJ2104 · Accepted Answer · 2017-09-19 17:40:17Z

3

String query = "SELECT * FROM Table_Name WHERE Col_Name='name'"; Cursor cursor = mDb.rawQuery(query, null);

edited Sep 19, 2017 at 17:40

answered Sep 18, 2017 at 18:14

PJ2104

1327 bronze badges

1 Comment

Donald Duck is with Ukraine Over a year ago

While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value.

Godric · Accepted Answer · 2013-08-20 13:54:31Z

Try this:

String vg ="Veg"; return database.rawQuery("SELECT * FROM subjects where " + KEY_CATEGORY + " = ?", new String[]{vg});

Rishi Gautam · Accepted Answer · 2013-09-19 11:07:49Z

 String q="SELECT * FROM todo WHERE category='" + vg +"'"; SQLiteDatabase db = this.getWritableDatabase(); Cursor cursor = null; cursor = db.rawQuery(q, null); if (cursor.moveToFirst()) { do { } while (cursor.moveToNext()); }

Manish · Accepted Answer · 2017-02-17 05:13:53Z

String selectQuery = "select * from " + TABLE; sqlDatabase = this.getWritableDatabase(); Cursor cursor = sqlDatabase.rawQuery(selectQuery, null); if (cursor != null) { cursor.moveToFirst(); } return cursor;

this will help you..

Danon · Accepted Answer · 2018-08-02 14:14:54Z

public List<String> getAllData(String email) { db = this.getReadableDatabase(); String[] projection = {email}; List<String> list = new ArrayList<>(); Cursor cursor = db.query(Table_name,null,"email=?",projection,null,null,null,null); // cursor.moveToFirst(); if(cursor.moveToFirst()) { do { list.add(cursor.getString(cursor.getColumnIndex("id"))); list.add(cursor.getString(cursor.getColumnIndex("name"))); list.add(cursor.getString(cursor.getColumnIndex("email"))); list.add(cursor.getString(cursor.getColumnIndex("password"))); // cursor.moveToNext(); } while (cursor.moveToNext()); } return list; }

Muhammad Qasim · Accepted Answer · 2020-01-01 04:44:04Z

here you can pass value for filter on

 public ArrayList<PlayListModel> getPlaylist(String playlistName) { SQLiteDatabase db = this.getReadableDatabase(); ArrayList<PlayListModel> obj = new ArrayList<PlayListModel>(); Cursor cursor = db.query(TABLE_PLAYLIST, new String[] { KEY_ID, KEY_TITLE, KEY_SINGER , KEY_PATH , KEY_PLAYLISTNAME , KEY_DUR }, KEY_PLAYLISTNAME+ "=?", new String[] { playlistName }, null, null, null, null); if (cursor != null) cursor.moveToFirst(); PlayListModel contact = new PlayListModel (cursor.getString(1), cursor.getString(2),cursor.getString(3), cursor.getString(4),cursor.getString(5)); obj.add(contact); // return contact return obj; }

Sayantan Kar · Accepted Answer · 2022-09-28 11:09:53Z

String query = "SELECT item_name FROM todo WHERE category =" + vg ; Cursor cursor = database.rawQuery(query,null); if (cursor.moveToFirst()) { while (cursor.isAfterLast() != true) { string itemname = cursor.getString(cursor.getColumnIndex("item_name"))); } }

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

How to retrieve specific data from particular column?

10 Answers 10

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

1 Comment

Comments

Comments

1 Comment

Comments

Comments

Comments

Comments

Comments

1 Comment

Linked

Related