MySQL update Loop -> how to

I want to loop the following command, for all distinct values in a column

upd开发者_StackOverflow中文版ate myTable set myUglyField = replace(myUglyField,'<trimmed distinct value here>\r\n','<trimmed distinc value here>');

Anyone know if this could be done, instead of going one by one to remove \r\n

If you run that query you have right there it will update ALL rows in the table, so I think you're good.

Suppose you have all replacements in a table (3 columns, in which value, what to replace and the replacement), you can write:

update myTable join replacements on myTable.myUglyFied = replacements.in_value
set myUglyField = replace(myUglyField, replacements.what_to_replace, replacements.replacement)