根据条件获取指定记录 update cities set end_time=REPLACE(end_time,end_time,SUBSTRING(end_time,1,5)) where end_time is not null ;