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 
 But I was just wondering if something same could be done in one query? ``` update mytable SET title = TRIM(title, '
') 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)

Accepted Answer

your syntax is wrong:

```
update mytable SET title = TRIM(TRAILING '
' FROM title)
```

Addition:

If the newline character is at the start of the field:

```
update mytable SET title = TRIM(LEADING '
' FROM title)
```

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

Solution

Problem