title: Find and Replace specific text and random numbers with mySQL Query
body: <p>I am using mySQL Workbench to edit data in columns. The data is in the form of</p>
  
  <p>[random integer 1][constant string][Data I want to keep intact][random Integer 2]</p>
  
  <p>I want to develop a query to remove the [Random integers] on the beginning and end as well as the [constant string].
  I can remove the [constant string] using a script like:</p>
  
  <pre><code>update [table_name] set [column_name] = replace([column_name], '[constant string]','');
  </code></pre>
  
  <p>But then i am still left with:
  [random integer 1][Data I want to keep intact][random Integer 2].</p>
  
  <p>Can anyone help me write a script to use in mySQL Workbench that will work for the entire table? I have more than one by the way and some are very large, all with the same pattern problem.
  Examples of this integer are: "16", "123", "225" and such. It is always 1-3 digits.</p>
  
  <p>To reiterate, I want something that will strip [random integer 1],[constant string] and [random Integer 2]
  from [random integer 1][constant string][Data I want to keep intact][random Integer 2]</p>
  
  <p>An example of what this looks like before and after is:</p>
  
  <pre><code>rows
  "85-STRING-Undo 250"
  "140-STRING-js: E.undo(); 194" 
  
  Desired result
  "Undo"
  "js: E.undo();"
  </code></pre>
  
  <p>This may be similar to another question, but I could not get any answer I needed from it.</p>