MYSQL字符替换语句
mysql> update `table_name` set field = replace(field,'.rar','.7z');
t...
t...
#字段
t...
mysql查询替换语句
UPDATE `table_name` SET `field_name` = replace (`field_name`,'from_str','to_str') WHERE `field_name`...
Please wait, page is loading...
mysql> update `table_name` set field = replace(field,'.rar','.7z');