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)