How to use "UPDATE Products SET Price = Price + 50 WHERE ProductID = 1" this kind of SQlite statement in android?

I want to update the a specific row of the Column.I tried to use the statement to set my value using 'db.update()'.But I cant.Is there any method which I can use to use the statement of the title to set the value of a specific row of a column?

Although the documentation explicitly mentions that the recommended and proper way to update a table is the method update(), your requirement can only be done with execSQL().<br/>

Either with execSQL(String sql):

db.execSQL("UPDATE Products SET Price = Price + 50 WHERE ProductID = 1");

or with execSQL (String sql, Object[] bindArgs):

db.execSQL(
    "UPDATE Products SET Price = Price + ? WHERE ProductID = ?",
    new String[] {"50", "1"}
);

This may help you. db.update() with ContentValues () is more safe updating method. Check this one.

     int i = 50;
     Cursor res = db.rawQuery("select * from Products where ProductId = 1 LIMIT 1");
      if(res.getCount() > 0){
            i += Integer.parseInt(res.getString(res.getColumnIndex("Price")));
        }
    
     ContentValues values = new ContentValues();
     values.put("Price", i.toString());
     db.update("Products",values,"ProductId = ?",new String[]{"1"});

I am not sure but I think that the problem may be setting Price column type as text. If so, change it integer.

To update your sql db use db.update(TABLE_NAME, values, where, whereArgs); You can read about here.The use case can look like this:

ContentValues cv = new ContentValues();
cv.put("column_name", "updated value");
db.update("table_name", cv, "column_id" +  "=?",new String[]{"primary_id"});

update() only works with ContentValues which is a wrapper for SQL variable binding. You can only bind values, not expressions like Price + 50.

To use an expression like that, use execSQL() with the raw SQL string you already have.

You can also try

db.execSQL(
"UPDATE Products SET Price = ? WHERE ProductID = ?",
new String[] {Price+50 , "1"}
);