android - How do I get a Cursor row with a certain value

Question

I have

var profileDatabase: SQLiteDatabase

I need to use it to get a Cursor with just the row I want with all the columns in it

If I have data like

name	age	color
Sam	12	White
John	13	Blue

question from:https://stackoverflow.com/questions/65904030/how-do-i-get-a-cursor-row-with-a-certain-value

Answer 1

Try to use this

 Cursor cursor;
 String[] columns = {"name", "age", "color"};
 cursor = sqLiteDatabase.query("profile_table", columns, "name=?", new String[]{"Sam"}, null, null, null);
 if (cursor != null) {
 cursor.moveToFirst();
 }