[mysql]replace

mysql中有一个字段后面多了'\r\n'，需要删除

update poems set author = replace(author,'\r\n','');