NutzCN Logo
问答 MySQL 如何提取字段中的汉字!
发布于 2333天前 作者 sunhai1988 3140 次浏览 复制 上一个帖子 下一个帖子
标签:

现在需要通过mysql 字段中的中文。然后插入到另外一张表。有什么函数可以吗? replace 不支持正则!

{"result":"BF00103;账户余额不足"}
{"version":"4.0.0.0","req_reserve":"","itionl_ino":"","resp_oe":"0000","resp_ms":"交易成功","memer_i":"1157860","terminl_i":"37332","t_type":"son","txn_type":"0431","txn_su_type":"16","iz_type":"0000","tre_te":"20180511095305","trns_seril_no":"519862440580","trns_i":"52233548444963","usiness_no":"20180511095253010431145481470936","su_mt":"75000"}
{"version":"4.0.0","req_reserve":null,"itionl_ino":null,"resp_oe":"0000","resp_ms":"交易成功","memer_i":"1196157","terminl_i":"37478","t_type":"son","txn_type":"0431","txn_su_type":"13","iz_type":"0000","tre_te":"20180224200518","trns_i":"60254e8497305264e9e08","trns_no":"201802240110001704709281","su_mt":"272000","trns_seril_no":"52820204234","ori_tre_te":null,"ori_trns_i":null,"orer_stt":null}
{"result":"其他方式还款成功"}
{"result":"其他方式还款成功"}
{"result":"0000;交易成功"}
{"result":"其他方式还款成功"}
{"version":"4.0.0","req_reserve":null,"itionl_ino":null,"resp_oe":"BF00103","resp_ms":"账户余额不足","memer_i":"1196157","terminl_i":"37478","t_type":"son","txn_type":"0431","txn_su_type":"13","iz_type":"0000","tre_te":"20180131200510","trns_i":"8067276804888930e5795903","trns_no":null,"su_mt":null,"trns_seril_no":"41e979244e335","ori_tre_te":null,"ori_trns_i":null,"orer_stt":null}
{"version":"4.0.0","req_reserve":null,"itionl_ino":null,"resp_oe":"0000","resp_ms":"交易成功","memer_i":"1196157","terminl_i":"37478","t_type":"son","txn_type":"0431","txn_su_type":"13","iz_type":"0000","tre_te":"20180119200500","trns_i":"17e135143358061e95","trns_no":"201801190110001589736339","su_mt":"70000","trns_seril_no":"813287698947481e","ori_tre_te":null,"ori_trns_i":null,"orer_stt":null}
{"version":"4.0.0.0","req_reserve":null,"itionl_ino":null,"resp_oe":"0000","resp_ms":"交易成功","memer_i":"1157860","terminl_i":"34303","t_type":"son","txn_type":"0431","txn_su_type":"13","iz_type":"0000","tre_te":"20180407200534","trns_i":"4654424342e30408","trns_no":"201804070110001847323740","su_mt":"160000","trns_seril_no":"ee9458e2744147","ori_tre_te":null,"ori_trns_i":null,"orer_stt":null}
1 回复

replace(replace(replace(name,"c",""),"b",""),"a","") 这样太傻了

添加回复
请先登陆
回到顶部