Replace function in SQLITE

Question

I was trying to duplicate this SQLite statement from the line of code below:

Cursor cursor = db.rawQuery("update tbl_details SET ticket = replace(ticket, " + tempID + ", " + ticket + ")", null);

to this one:

SQLiteDatabase db = this.getWritableDatabase();
        ContentValues cv = new ContentValues();
        cv.put("ticket", "replace(ticket, " + tempID + ", " + ticket + ")");
        db.update("tbl_details", cv, null, null);
        return true;

What I am trying to do is to get a New ID and replace all instances of the old temporary ID in the database. But the code above is changing all the records in ticket column.

Please help. Thank you!

Well: update(...): whereClause the optional WHERE clause to apply when updating. Passing null will update all rows. You pass null, hence all rows are affected. — dhke
– dhke, Commented Jan 22, 2016 at 14:40

laalto · Accepted Answer · 2016-01-22 16:39:18Z

2

You can use ContentValues to bind literal values only, not expressions like replace(...).

To run the raw UPDATE SQL, just use execSQL() instead of rawQuery(). rawQuery() alone won't actually run the code until the returned Cursor is moved.

answered Jan 22, 2016 at 16:39

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Collectives™ on Stack Overflow

Replace function in SQLITE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related