sqlite query using WHERE and AND in android studio

Question

So I am trying to select the count where a value = value* conditional to another boolean value being true. I wrote a query as such I am new to sqlite so I am sorry in advance for syntax:

public int getPlaceCount(String name){
    SQLiteDatabase db = this.getWritableDatabase();
    String query = "SELECT COUNT(*) FROM " + TABLE + " WHERE " + NAME + " = ? AND " + CURRENT + " <> ?";
    String value = "0";
    Cursor cursor = db.rawQuery(query,new String[]{name,value});
    int count = cursor.getInt(cursor.getColumnIndex("COUNT(*)"));
    return count;
}

now in mysql I would do something like this:

select count(*) from TABLE where NAME='name' and CURRENT=1;

thanks in advance

Leo R · Accepted Answer · 2018-12-11 00:53:58Z

1

I figured it out. I needed to move cursor to first:

cursor.moveToFirst();

answered Dec 11, 2018 at 0:53

Leo R

631 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

sqlite query using WHERE and AND in android studio

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related