[mysql]replace

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

update poems set author = replace(author,'
','');