Li-Fan Chen says to YSITD
UPDATE students_new SET studentid= CONCAT('9',studentid) WHERE studentid LIKE '710%'