remove enter mark in varchar column

My Data has "enter" mark in one of the columns. How do I remove it and display the text 开发者_开发技巧on a single line? phpMyAdmin does show that word on 2 lines.

update table set field=replace(field, "\n", "");