title: Replace a word in BLOB text by MySQL
body: <p>I've got a huge mysql table (called <code>tcountriesnew</code>) and a column (called <code>slogen, blob type</code>).
  In each of those <code>slogen</code> blobs I'd like to replace a word, for example: <code>banana</code> to <code>apple</code>.</p>
  
  <p>Unfortunately I tried to print all the rows with word banana, and it did not work.</p>
  
  <p><code>select * from tcountriesnew where slogen like '%banana%';</code></p>
  
  <p>Please help me.</p>
  
  <ul>
  <li>What i missed, what is the problem with my query?</li>
  <li>How can i replace text in blob?</li>
  </ul>