mysql 字符串截取

SELECT SUBSTRING(remark,36,LENGTH(remark)-35) FROM product

UPDATE product SET remark=SUBSTRING(remark,36,LENGTH(remark)-35)

posted @ 2013-02-04 21:52  dami.van  阅读(120)  评论(0)    收藏  举报