title: Increase products price by 10%
body: <p>I am having problems increasing the prices of my hp products by 10%.</p>
  
  <p>Here is what I've tried -->></p>
  
  <pre><code>UPDATE products SET price = price*1.1;
  from products 
  where prod_name  like 'HP%'
  </code></pre>
  
  <p>Here is a picture of the products table:</p>
  
  <p><img src="https://i.stack.imgur.com/fwgoX.png" alt="enter image description here"></p>