Blog

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','');
Zoeken