专题文章
时长:00:00更新时间:2020-11-09 18:59:54
replaceMYSQL字符替换函数sql语句分享(正则判断)_MySQL:bitsCN.com Update dede_addonsoft SET dxylink=REPLACE(dxylink, '.zip', '.rar') where aid > 45553; update `table_name` set field = replace(field,'.rar','.7z'); table_name:要查询的表名, field:表里的字段名, replace(field,'.rar','.7z'); :正则匹配,把field字段里的 .r
查看详情