Take the 2-minute tour ×

I need to update multiple rows in sqlite where each row gets a different value.

Currently I'm just looping on the update statements. (I'm using SQLStatement and replacing the parameters).

I know that with MySql there is an option to use the CASE command to execute one update that will update all rows with the matching values.

Is there any similar thing in sqlite?


share|improve this question
add your update code here....... –  Sandip Armal Patil Apr 8 '12 at 8:20
add comment

1 Answer

If you know how your query should look like you can use either query() or rawQuery() methods instead of update

share|improve this answer
it doesn't seem to work. I've concatenated the update queries, separating them with semi-colons and used rawQuery. The code runs but the table isn't updated. –  Ran Apr 8 '12 at 10:34
add comment

Your Answer


