If you trying to apply a global text string with an replace , than use this:
|
1 2 3 4 5 6 |
update `your_sql_table` set `field_from_your_sql_table` = replace( `field_from_your_sql_table`, 'wrong_word', 'good_word' ); |
The your_sql_table is the name of the table.
The field_from_your_sql_table is the field with records where will be find and repleced words.
The wrong_word is the word search and replace by good_word
