UPDATE YOUR_TABLE SET sort_order = sort_order + 1 WHERE sort_order >= 2 INSERT INTO YOUR_TABLE (value, sort_order) VALUES('new value', 2) UPDATE YOUR_TABLE SET sort_order = sort_order + 1 WHERE sort_order >= 2 INSERT INTO YOUR_TABLE (value, sort_order) VALUES('new value', 2) UPDATE YOUR_TABLE SET sort_order = sort_order + 1 WHERE sort_order >= 2 INSERT INTO YOUR_TABLE (value, sort_order) VALUES('new value', 2)