Android :如何OnConflictStrategy.REPLACE但保留一个特定的字段

// 定义数据表的结构
public class MyTable {
    public static final String TABLE_NAME = "my_table";
    public static final String COLUMN_ID = "id";
    public static final String COLUMN_NAME = "name";
    public static final String COLUMN_SPECIAL_FIELD = "special_field";

    // 创建数据表的SQL语句
    public static final String CREATE_TABLE =
            "CREATE TABLE " + TABLE_NAME + "(" +
                    COLUMN_ID + " INTEGER PRIMARY KEY," +
                    COLUMN_NAME + " TEXT," +
                    COLUMN_SPECIAL_FIELD + " TEXT" +
                    ")";
}

// 在插入数据时处理冲突并保留特定字段
ContentValues values = new ContentValues();
values.put(MyTable.COLUMN_ID, 1);
values.put(MyTable.COLUMN_NAME, "John");
values.put(MyTable.COLUMN_SPECIAL_FIELD, "Special Value");

SQLiteDatabase db = dbHelper.getWritableDatabase();
db.insertWithOnConflict(MyTable.TABLE_NAME, null, values, SQLiteDatabase.CONFLICT_REPLACE);
db.close();