How to remove \n in Mysql field?

Question

PHP

Hi all.
There is a simple table Streets , There is one string expression in the name field, but \n got there, i.e. line break.
The question is how to cut it out with a MYSQL query?
Mind was only enough for
UPDATE Streets SET name = TRIM(name)
Well, and a couple of other variations did not work

Answer 1

UPDATE Streets SET name = REPLACE(name, "\n", "")
Trim, according to the docs, can also:
TRIM(BOTH "\n" FROM name)