title: Read Data from 2 different columns and use that data to create another column in the same table
body: <p>I am trying to see if this is even possible, if so i would need some insight on how to do this.</p>
  
  <p>I have created a statement below</p>
  
  <pre><code>select wp_cart66_orders.*, wp_cart66_order_items.* from wp_cart66_orders, wp_cart66_order_items where wp_cart66_orders.id=wp_cart66_order_items.order_id and wp_cart66_orders.status = 'new';
  </code></pre>
  
  <p>the 2 colums that i am looking at are </p>
  
  <pre><code>item_number and product_price 
  </code></pre>
  
  <p>within the 2 columns the data looks like below
  item_number:purp1
  product_price: 53.00</p>
  
  <p>each time i see purp1 and 53.00 i want to insert a 13 in that same table in a new column called weight</p>
  
  <p>does that make sense? is this even possible in mysql?</p>