title: MySQL search and replace some text in a field
body: <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>