例如:video表
views字段中,只保留数字,删掉多余英文字符
update video set views=replace(views," views","") where id BETWEEN 946573 AND 9476051;
例如:video表
views字段中,只保留数字,删掉多余英文字符
update video set views=replace(views," views","") where id BETWEEN 946573 AND 9476051;