<p>What MySQL query will do a text search and replace in one particular field in a table?</p>

<p>I.e. search for <code>foo</code> and replace with <code>bar</code> so a record with a field with the value <code>hello foo</code> becomes <code>hello bar</code>.</p>

The
Replace
string function will do that.