Replace words in the fields of table using SQL.
If you trying to apply a global text string with a replacement, then 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 found and replaced words.
The wrong_word is the word search and replace by good_word
