mysql - What would be a sql query to remove \n\r from the text? -

i using mysql. data has column called text, uses text data type.

there several newlines each record in column. want remove new lines sql query. how can that?

try 1 -

create table table1(column1 text); insert table1 values ('text1\r\ntext2 text3');  select * table1; -------- text1 text2 text3  update table1 set column1 = replace(column1, '\r\n', ''); select * table1; -------- text1text2text3