title: Update a cell in sql table with multiple scenarios
body: <p>I have a cell with value <code>cell = '0,B,1,D,4,T...'</code> (worst case)</p>
  
  <p>What I want is updating the value to be <code>'b,B,d,D,t,T...'</code> (best case)</p>
  
  <p>Sometimes I find the value can be <code>'0,B,d,D,t,T..'</code> so its value is not fixed.</p>
  
  <p>What I want to do is do a sort of multiple checking in the cell and replace the bits that I want until it has the best case value. e.g :</p>
  
  <pre><code>UPDATE some_table
  SET    some_table.some_col = REPLACE(some_table.some_col, '0,B', 'b,B')
  WHERE  some_table.some_row = 'RELATED_ROW'
         AND some_table.some_col LIKE'%0,B%'
  
  UPDATE some_table
  SET    some_table.some_col = REPLACE(some_table.some_col, '1,D', 'd,D')
  WHERE  some_table.some_row = 'RELATED_ROW'
         AND some_table.some_col LIKE'%1,D%'
  .
  .
  .
  </code></pre>
  
  <p>But I want know if it's possible to do it in a single statement? so that I don't have to execute lots of separated <code>UPDATE</code> scripts. </p>