Android Sqlite Cursor - Check if next row contains same value

Question

I am trying to compare cursor data, which is extracted from a SQLite database. It just has to be one column cursor.getString(1);

However, how can I check if that column has the same value in the next cursor row? (not the next column!) Using cursor.moveToNext();?

To paraphrase, I want to find a way to check column 1 for duplicate String entries using Cursor object.

Why don't you just extract unique data, by simply using the SQL keyword DISTINCT in your query? — Phantômaxx
– Phantômaxx, Commented Feb 27, 2016 at 10:16

Community · Accepted Answer · 2017-05-23 12:07:30Z

0

Based on the solution from this answer, this is the code you might want to use:

String checkedValue = cursor.getString(1);

while(cursor.moveToNext()){
    String value = cursor.getString(1);
    if(value.equals(checkedValue)){ 
        // TODO: duplicate value found, do something
        break;
    }
}

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Feb 27, 2016 at 9:29

archived

6578 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

Android Sqlite Cursor - Check if next row contains same value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related