bitian中的数据换成(就是删除.com)
执行sql语句:update table_name set bitian = REPLACE(bitian,'.com','') where bitian like'%.com%'