20 october 2016 MySQL - remove CR+LF Remove a Carriage Return and Line Feed from a MySQL table column: UPDATE my_table SET my_column = replace(my_column,'\r\n',''); UPDATE my_table SET my_column = replace(my_column,'\n','');