title: SQL to remove partial text from value
body: <p>How would I write the SQL to remove some text from the value of records if it exists. </p>
  
  <pre><code>Version Column data
   ------------------  
  WEB 1.0.1  
  WEB 1.0.1  
  1.0.2  
  1.0.2  
  </code></pre>
  
  <p>I would like to update all records that contain "WEB " and remove that text but leave the rest, "1.0.1". </p>
  
  <p>So far I  have <code>Select * from table</code>. </p>
  
  <p>Database is MySQL 5.5.25</p>