1. update + replace
update t_looptest_time set end_time = replace(end_time,'2018','2017') where group_id in ('1525400951110X7Z6ZJ','1525400669663WLN42Y','1525398755892LPV52Q',
)
