摘要:
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字段里的 .rar 替换为 .7z MySQL正则表达式替换 阅读全文