UPDATE ets_check_assets_tmp_yu yushibo SET yushibo.keeper = substr('5510李磊, 0553461', 1, instr('5510李磊, 0553461', ',' , 1, 1) - 1) WHERE yushibo.keeper = '5510李磊, 0553461'

说明：红色的，为数据中特殊字符的割点标示。

同事的写的SQL：

UPDATE ETS_CHECK_ASSETS_TMP ECAT
SET    ECAT.KEEPER = REPLACE(ECAT.KEEPER,
                             SUBSTR(ECAT.KEEPER, INSTR(ECAT.KEEPER, ',' ,1, 1)),
                             NULL)
WHERE  ECAT.KEEPER LIKE '%,%'