数据库里的表字段含有‘-’的修改

如图

我需要将‘-’去掉

修改

update id_name set player_id=REPLACE(player_id,'-','')

恢复

update id_name set player_id=REPLACE(player_id,'2','-2')

-----5/17更新

对于表字段blob数据查看

字段：beast_exchange_infos

表：beast_info

SELECT CAST( beast_exchange_infos AS CHAR) FROM beast_info;

SELECT CONVERT(beast_exchange_infos USING utf8mb4) as library FROM beast_info

SELECT HEX(beast_exchange_infos) FROM beast_info;