select max(sort_key) from cu_curriculums where package_id = :package_id and sort_key < :sort_order select min(sort_key) from cu_curriculums where package_id = :package_id and sort_key > :sort_order update cu_curriculums set sort_key = case when sort_key = :sort_order then $new_sort_order when sort_key = :new_sort_order then $sort_order end where package_id = :package_id and sort_key in (:sort_order, :new_sort_order)