UPDATE yourTable SET `text` = TRIM(REPLACE(REPLACE(REPLACE(`text`, ‘\n’, ‘ ‘), ‘\r’, ‘ ‘), ‘\t’, ‘ ‘));
Удалить перенос строки в поле MySQL
Добавить комментарий
UPDATE yourTable SET `text` = TRIM(REPLACE(REPLACE(REPLACE(`text`, ‘\n’, ‘ ‘), ‘\r’, ‘ ‘), ‘\t’, ‘ ‘));