title: updatepricing in MySQL where multiple prices are in same row
body: <p>I have been tasked to update the price list on our website. Currently, we have to do this one item at a time inside the Admin Panel.</p>
  
  <p>However, we have over 3000 items, and tiered pricing for each item (up to 5 tiers)</p>
  
  <p>Problem is, in the sell_prices table, the prices are structured like so:</p>
  
  <p><code>10.50:9.50:8.50;7.50;6.50</code> in one cell.</p>
  
  <p>I am attempting to write a script that will update each sell_price by 10%</p>
  
  <pre><code>UPDATE inv_items
  SET sell_prices = sell_prices * 1.10
  WHERE id = xxxxxx
  </code></pre>
  
  <p>I have also tried:</p>
  
  <pre><code>UPDATE inv_items
  SET sell_prices = sell_prices * 1.10; sell_prices = sell_prices * 1.10
  WHERE id = xxxxxx
  </code></pre>
  
  <p>But naturally received an error.</p>
  
  <p>This works great but only updates one record, and leaves the rest blank.</p>
  
  <p>Currently, I am working through PhpMyAdmin but I will write a new Price Increase script once I can figure this out.</p>
  
  <p>I have backed up the database.</p>