如何在SQLiteDatabase.delete(...)方法中使用"AND"和"OR"？

Question

我使用以下代码从Android中的表中删除一些行：

sqliteDb.delete("MYTABLE", "Tel" + " = ?", new String[] { "1" });

如何为以下3种查询类型调用此方法？

Delete from MYTABLE where Tel = 1 OR Tel = 2
Delete from MYTABLE where Tel = 1 AND Number = 2
Delete from MYTABLE where Tel = 1 OR Number = 2

Answer 1

一般来说，类似于：

String tableName = "MYTABLE";
String where = "Tel = ? or Number = ?";
String[] whereArgs = {"1", "2"};

如何选择一个版本的where（"Tel = ? or Number = ?"）与另一个版本（"Tel = ? AND Number = ?"）完全取决于您：）

Answer 2

您只需点赞即可。

sqliteDb.delete("MYTABLE", "Tel" + " = ? OR Tel" + " = ?", new String[] { "1",  "2" });