I have an Sqlite table that has a column for play\_order.  

If I delete an item is there a command to reorder the data to remove the now missing number from the column?

For example, say the table looks like this:

```
_id | play_order
----------------
1   | 0
2   | 1
3   | 2
4   | 3
5   | 4

```

I delete \_id 3, I'd like to reorder the play\_order so \_id 4 now has a play\_order of 2 and \_id 5 has 3 etc...

I can do this in Java (Android), but would rather do it in SQL if possible.

I've tried using a fake row id, but the data is all over the table and can be full of other random data at any point.

I've also thought of doing a subquery and getting all the data, but don't know if I can loop over it or something to set the the order.

As far as Android goes, I've looked into doing a "applybatch" on the contentresolver, but can't get that to work either.