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','');
Categorieën
MySQL