Database: How to find and replace database entries?

Occasionally it can be important to edit database entries directly in it. To find a specific record and replace it, the following SQL statement is possible:

UPDATE tabellenName SET tabellenWert = replace(tabellenWert,"alterEintrag","neuerEintrag");