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)
解决方案
your syntax is wrong:
update mytable SET title = TRIM(TRAILING '\n' FROM title)