How to remove new line characters from data rows in mysql

Question

I can loop through all of the rows in a php script and do  UPDATE mytable SET title      trim  row  title       where id       row  id        and trim can remove  n   But I was just wondering if something same could be done in one query    update mytable SET title   TRIM title    n   where 1 1   will it work  I can then just execute this query without requiring to loop through   thanks   PS  I could test it but table is quite large and dont want to mess with data  so just thought if you have tested something like this before

User · Answer

Removes trailing returns when importing from Excel  When you execute this  you may receive an error that there is no WHERE  ignore and execute    UPDATE table name SET col name   TRIM TRAILING   r  FROM col name

User · Answer

1  Replace all new line and tab characters with spaces   2  Remove all leading and trailing spaces    UPDATE mytable SET  title    TRIM REPLACE REPLACE REPLACE  title     n           r           t

User · Answer

For new line characters  UPDATE table name SET field name   TRIM TRAILING   n  FROM field name   UPDATE table name SET field name   TRIM TRAILING   r  FROM field name   UPDATE table name SET field name   TRIM TRAILING   r n  FROM field name     For all white space characters  UPDATE table name SET field name   TRIM field name   UPDATE table name SET field name   TRIM TRAILING   n  FROM field name   UPDATE table name SET field name   TRIM TRAILING   r  FROM field name   UPDATE table name SET field name   TRIM TRAILING   r n  FROM field name   UPDATE table name SET field name   TRIM TRAILING   t  FROM field name     Read more  MySQL TRIM Function

User · Answer

your syntax is wrong  update mytable SET title   TRIM TRAILING   n  FROM title   Addition  If the newline character is at the start of the field  update mytable SET title   TRIM LEADING   n  FROM title

User · Answer

UPDATE mytable SET title TRIM REPLACE REPLACE title    n          t

User · Answer

Playing with above answers  this one works for me    REPLACE REPLACE column name     n          r

User · Answer

update mytable set title trim replace REPLACE title CHAR 13      CHAR 10         Above is working for fine

User · Answer

UPDATE test SET log   REPLACE REPLACE log    r          n          worked for me   while its similar  it ll also get rid of  r n  http   lists mysql com mysql 182689

User · Answer

My 2 cents    To get rid of my  n s I needed to do a   n  Hope that helps someone   update mytable SET title   TRIM TRAILING    n  FROM title

[mysql] How to remove new line characters from data rows in mysql?

Examples related to mysql

Examples related to trim