Delete SQLite row with multiple WHERE arguments in Android

Question

I would like to delete a record in the database with multiple WHERE arguments.

My database helper class has this method:

    public void deleteManualRow(String where){
    try {db.delete(TABLE_NAME_MANUAL, where, null);}
    catch (Exception e)
    {
        Log.e("DB ERROR", e.toString());
        e.printStackTrace();
    }
}

The "where" string which is passed to this method is seen as this through the debugger:

eventName='Manual Event 6' AND eventStartTime='2011-07-18T05:40:00.000-0400' AND eventEndTime='2011-07-18T06:40:00.000-0400'

How am I supposed to structure this WHERE clause if I want to delete a record with multiple arguments for WHERE? All of the datatypes are strings.

Rasel · Accepted Answer · 2011-07-18 18:11:34Z

4

like this db.delete(TABLE_NAME_MANUAL,"Column1='5' and column2 like '3'", null);

edited Jul 18, 2011 at 18:11

answered Jul 18, 2011 at 18:05

Rasel

15.5k6 gold badges42 silver badges50 bronze badges

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

2 Comments

dell116 Over a year ago

Thank you for your response, but the error in my code wasn't because of my SQL syntax. I was trying to delete a record that actually didn't even exist, hence no result...very dumb mistake on my part. For discussions sake, I see that in your response you use 'like' instead of '=' for column2. Why use 'like' instead of '='? Are '=' and 'like' interchangeable because my code is working when using '=' for column2.

Rasel Over a year ago

still two is different you know

Murat Kurbanov · Accepted Answer · 2021-01-07 06:56:42Z

1

You have to learn your sqlite api, next I show from Android flutter example.

From sqlite_api.dart:

Future<int> delete(String table, {String where, List<dynamic> whereArgs});

So your result code will be:

await db.delete(tableName, where: 'place_id = ? and country_id = ?', whereArgs: [place_id, country_id]);

answered Jan 7, 2021 at 6:56

Murat Kurbanov

87712 silver badges14 bronze badges

Collectives™ on Stack Overflow

Delete SQLite row with multiple WHERE arguments in Android

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related