update coupon set memo = concat(left(memo, char_length(memo)-10)) where dayouhuiid is not null and memo like '%码号%';
mysql截取字符串
最新推荐文章于 2024-07-25 16:06:56 发布
update coupon set memo = concat(left(memo, char_length(memo)-10)) where dayouhuiid is not null and memo like '%码号%';