title: Update table column with different values
body: <p>I would like to pick your brains to solve a problem since I am new to <code>MySQL</code> and cannot get past to it :(</p>
  
  <p>I have a table named <code>"localgames"</code> and a column named <code>"Stock"</code>. The values into Stock are:</p>
  
  <pre><code>16Sold out
  18Sold out
  25Sold out
  50Sold out
  </code></pre>
  
  <p>I want to transform this all in "Sold out" and I have tried the following:</p>
  
  <pre><code>UPDATE localgames SET Stock = IF(Stock REGEXP '*.Sold out', 'Sold out', Stock);
  </code></pre>
  
  <p>Also tried</p>
  
  <pre><code>UPDATE localgames SET Stock = IF(Stock REGEXP '^[0-9]Sold out', 'Sold out', Stock);
  </code></pre>
  
  <p>Nothing seems to work. Can you please help me? Thanks</p>