mysql截取字符串

update coupon set memo = concat(left(memo, char_length(memo)-10)) where dayouhuiid is not null and memo like '%码号%';