REPLACE new line character in MYSql not working

Question

I executed following query and for some reason its not replacing new line character in database . It says Rows matched 1 but no change . What can be wrong ?

mysql> UPDATE aboutme SET abouttext=REPLACE(abouttext,'\\n','') WHERE userid='5099a95cd944b8.22468149'; Query OK, 0 rows affected (0.00 sec) Rows matched: 1  Changed: 0  Warnings: 0 

Answer 1

You can match a newline character using \n, not \\n.

Code:

 UPDATE aboutme   SET abouttext=REPLACE(abouttext,'\n','')   WHERE userid='5099a95cd944b8.22468149'; 

Answer 2

If \n does not work as in my case, the following worked \r\n

UPDATE aboutme  SET abouttext=REPLACE(abouttext,'\r\n','')  WHERE userid='5099a95cd944b8.22468149'; 

In my case it has been a web application.