幸运飞艇停吗

ASP源碼.NET源碼PHP源碼JSP源碼JAVA源碼DELPHI源碼PB源碼VC源碼VB源碼Android源碼
當前位置:首頁 >> 數據庫 >> MySql >> Mysql如何批量去掉某一個字段內的特殊字符串

Mysql如何批量去掉某一個字段內的特殊字符串

來源:網絡整理     時間:2018-10-17     關鍵詞:

BENPIANWENZHANGZHUYAOJIESHAOLE" MysqlRUHEPILIANGQUDIAOMOUYIGEZIDUANNEIDETESHUZIFUCHUAN",ZHUYAOSHEJIDAOFANGMIANDENEIRONG,DUIYUMySqlGANXINGQUDETONGXUEKEYICANKAOYIXIA: ZAIMYSQLDESHUJUKULIKENENGCUNZAIMOUYIZIDUANHOUMIANYOUTESHUZIFUDEQINGKUANG,RUOMINGQUEZHIDAOGAILIEKENENGYINRUDEZIFULEIXING,ZEZHIJIESHIYONGTIHUANGONGNENGJINXINGTIHUANLIRUUPDATE tablename S...

幸运飞艇停吗ZAIMYSQLDESHUJUKULIKENENGCUNZAIMOUYIZIDUANHOUMIANYOUTESHUZIFUDEQINGKUANG,RUOMINGQUEZHIDAOGAILIEKENENGYINRUDEZIFULEIXING,ZEZHIJIESHIYONGTIHUANGONGNENGJINXINGTIHUANLIRU

UPDATE tablename SET  field = REPLACE(REPLACE(field, CHAR(10), ”), CHAR(13), ”);

char(10):  換行符
char(13):  回車符

幸运飞艇停吗DANYOUSHIHOUBINGBUZHIDAOZIFUCHUANHOUMIANDEJUTIZIFUSHISHENME,ZEKEYITONGGUO16JINZHIZHUANHUAN,BIDUIDANGQIANWENZIZHUANHUAMAJIQUDIAOTESHUZIFUDEZHUANHUAMA。

LI




 在這里 可以明顯看到兩個之前有些差異有特殊字符的轉化之后為E78E8BE58B87E38080,無特殊字符的轉化之后為E78E8BE58B87。兩者之間多了一個E58B87。

幸运飞艇停吗KANDAOZHELI,JIUHAOBANLE,ZHIJIESHIYONGTIHUANHANSHUJIANGE58B87ZHUANHUAWEIKONGJIKE。ZAIZHELIZHUYI:

幸运飞艇停吗16JINZHIXUQIANMIANZENGJIA0x。ZUIZHONGSQLRUXIA

UPDATE gt_user SET NAME = REPLACE(NAME, 0xE38080, '')

YISHANGJIUJIESHAOLE MysqlRUHEPILIANGQUDIAOMOUYIGEZIDUANNEIDETESHUZIFUCHUAN,BAOKUOLEFANGMIANDENEIRONG,XIWANGDUIMySqlYOUXINGQUDEPENGYOUYOUSUOBANGZHU。

幸运飞艇停吗 BENWENWANGZHILIANJIE:http://snifly.cn/article/detail_4593344.html

相關圖片

相關文章