mysql中如何将insert语句修改为update语句

原来的插入sql语句
INSERT INTO `phome_ecms_news_data_1` (`id`, `keyid`) VALUES (1, '22,23,24');
第一步，将INSERT INTO替换为update
update `phome_ecms_news_data_1` (`id`, `keyid`) VALUES (1, '22,23,24');
第二步将VALUES (  替换为   `id`=
update `phome_ecms_news_data_1` (`id`, `keyid`) where `id`=1, '22,23,24');
第三步将 (`id`, `keyid`)  替换为 set `keyid`=
update `phome_ecms_news_data_1` set `keyid`= where `id`=1, '22,23,24');
第四步：将insert语句修改为update语句需要的正则替换规则
替换正则：`keyid`= where `id`=([0-9]+), (.*?)\);
替换后的规则：`keyid`=$2 where `id`=$1;
修改后变成
update `phome_ecms_news_data_1` set `keyid`='22,23,24' where `id`=1;