Mysql: Search + Replace within Fields

Imagine you want to search and replace some text/string content within a column:

UPDATE <table>
SET <column> = replace(<column>, "find this string", "replace found string with this string");

Example for replacing a full url that points to an old domain which does not exist anymore or has moved:

UPDATE wordpress_content_table
SET wp_content_column = replace(wp_content_column, "http://www.oldserver.com/wp", "http://www.now-and-cool.com/wp");