remove enter mark in varchar column

Question

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.

Answer 1

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