Swapping two rows in SQLite.

update item
    set row = (case when row = 1 then 2 else 1 end)
    where row in (1, 2);