笔记 · 2017-11-18 18:15 · 566 阅读

mysql字段数据替换/截取

mysql

UPDATE may_book SET content = replace(content, substring(content,-8), '')

UPDATE may_comics_img SET `value` = replace(`value`, '/test/', '/comics/')