mysql更新移除逗号分割字符串中部分字符

    UPDATE t_robot_team
    SET chat_words = TRIM(BOTH ',' FROM REPLACE( CONCAT( ',', chat_words, ',' ), CONCAT( ',', 21, ',' ), ',' ))
    WHERE 
    locate(CONCAT(',',21,','),CONCAT(',',chat_words,','));