title: Product Variant Affecting all Rows with Keyword in MySQL
body: <p>I am trying to update table inventories across two (<code>inventory</code>, <code>sold</code>) MySQL tables.</p>
  
  <p>Let's say the sku we are dealing with is <code>BT888-16</code></p>
  
  <pre><code>UPDATE inventory JOIN sold
  ON inventory.sku = sold.sku
  SET inventory.quantity = inventory.quantity - sold.quantity
  </code></pre>
  
  <p>This works as expected, but <code>BT888-16</code> is a product variant for the <code>BT888</code> sku.</p>
  
  <p>How would I make it so that <code>BT888-16</code> in <code>sold</code> affects all quantity rows with <code>BT888</code> in <code>inventory</code>?</p>
  
  <p>For example, <code>BT888-16</code> should affect all quantity rows with the phrase <code>BT888</code> in it?  <code>BT888</code> <code>BT888-01</code> <code>BT888-02</code> <code>BT888-03</code> -- all the way up to <code>BT888-***</code></p>