What is the correct way to change the value of SQL columns?

Question

MySQL

Hello.
There is a table, there is a text column, where the usual text is for each news, you need to select and replace the word where the word "Aloha" is present with the word "User" - while the rest of the text of the news does not change. What is the best way to solve this problem?

Answer 1

https://dev.mysql.com/doc/refman/5.5/en/string-fun...

UPDATE myTable SET txt=REPLACE(txt, 'Aloha', 'User')