SQLite database update query with multiple where conditions in Android

Question

I want to update my database table with multiple where conditions. I already did with single where condition

db.update(TABLE_MISSING_ITEMS, values, KEY_AUTHOR + " = ?",
                new String[] { String.valueOf(items.getAuthor()) });

Now i want 2 where condition.

P.S :- No raw query

follow this link : stackoverflow.com/questions/9185441/…

Pragnesh Ghoda シ
– Pragnesh Ghoda シ

2014-09-09 05:42:46 +00:00
Commented Sep 9, 2014 at 5:42 — Pragnesh Ghoda シ
– Pragnesh Ghoda シ, Commented Sep 9, 2014 at 5:42
Use rawQuery in that put normal sql query for update.

VVB
– VVB

2014-09-09 05:49:25 +00:00
Commented Sep 9, 2014 at 5:49 — VVB
– VVB, Commented Sep 9, 2014 at 5:49

Manas Bajaj · Accepted Answer · 2014-09-09 05:44:14Z

50

You can separate the different WHERE conditions with ANDlike this:

db.update(TABLE_NAME,
    contentValues,
    NAME + " = ? AND " + LASTNAME + " = ?",
    new String[]{"Manas", "Bajaj"});

answered Sep 9, 2014 at 5:44

Manas Bajaj

1,1333 gold badges18 silver badges26 bronze badges

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

Comments

Samir · Accepted Answer · 2018-03-10 20:06:17Z

The way I solved my need

   public boolean checkHususiKayit(String baslik, String tarih) {
    boolean varMi = false;
    SQLiteDatabase database = dbHelper.getReadableDatabase();
    final String kolonlar[] = {DBHelper.COLUMN_H_ID,
            DBHelper.COLUMN_H_ID,
            DBHelper.COLUMN_H_BASLIK,
            DBHelper.COLUMN_H_TARIH,
            DBHelper.COLUMN_H_YOK_TUR,
            DBHelper.COLUMN_H_AD,
            DBHelper.COLUMN_H_WEB_ID,
            DBHelper.COLUMN_H_NUMARA,
            DBHelper.COLUMN_H_YURD_ID,
            DBHelper.COLUMN_H_YETKILI_AD,
            DBHelper.COLUMN_H_YETKILI_ID,
            DBHelper.COLUMN_H_TEL,
            DBHelper.COLUMN_H_EMAIL,
            DBHelper.COLUMN_H_ADDRESS,
            DBHelper.COLUMN_H_VAR,
            DBHelper.COLUMN_H_GOREVLI,
            DBHelper.COLUMN_H_YOK,
            DBHelper.COLUMN_H_IZINLI,
            DBHelper.COLUMN_H_HATIMDE};

    String whereClause = DBHelper.COLUMN_H_BASLIK + " = ? AND " + DBHelper.COLUMN_H_TARIH + " = ?"; // HERE ARE OUR CONDITONS STARTS
    String[] whereArgs = {baslik, tarih};


    Cursor cursor = database.query(DBHelper.TABLE_NAME_HUSUSI, kolonlar, whereClause, whereArgs, null, null, null + " ASC");
    while (cursor.moveToNext()) {
        varMi = true;
    }
    database.close();
    cursor.close();
    return varMi;
}

Deepa MG · Accepted Answer · 2016-11-18 12:01:04Z

0

THIS CAN ALSO BE DONE LIKE THIS

public void UpdateData(int Cid,int flag,String username,String password)
    {
        SQLiteDatabase database = this.getWritableDatabase();
        ContentValues cv = new ContentValues();

          cv.put("Status",flag);//I am  updating flag here

        database.update(TABLE_NAME, cv, ""+KEY_UserName+"= '"+ username+"' AND "+KEY_CID+"='"+Cid+"'  AND "+KEY_Password+"='"+password+"'" , null);
        database.close();
    }

answered Nov 18, 2016 at 12:01

Deepa MG

1961 silver badge16 bronze badges

Comments

Syed Danish Haider · Accepted Answer · 2017-06-08 18:54:23Z

0

Try this simple query db.update(TABLE_FF_CHECKLIST_DATA,contentValues, "FFCHECKLISTID = ? and TASK_ID_CHK = ?" , new String[] {"EHS" , "CTO914"});

where "EHS" is value in column FFCHECKLISTID and CTO914 is value in TASK_ID_CHK.

answered Jun 8, 2017 at 18:54

Syed Danish Haider

1,4141 gold badge14 silver badges16 bronze badges

Collectives™ on Stack Overflow

SQLite database update query with multiple where conditions in Android

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related