How to change multiple records of an sql table at once?

Question

Imagine a result of an SQL:

ID - NOME- MENSAGEM

1 / israel / msg-olamundo
2 / rafael / msg-olamundo
3 / augusto / msg-olamundo

Now I want to do in SQL the same thing that str_replace would do in php take all records of an x the word "msg-".

Researching I found the answer and wanted to put here to help the crowd is very easy!

Answer 1

update tabela
   set mensagem = REPLACE(mensagem, 'msg-', 'NOVO TEXTO AQUI OU DEIXAR VAZIO PARA APAGAR') 
 where `mensagem` LIKE '%msg-%'