UPDATE ladder_table 
SET ladder_ranking = ladder_ranking -1 
WHERE ladder_ranking >= 17 
AND ladder_ranking < 2345