UPDATE table1 SET sort_order = 1 WHERE state = "Virginia"