title: Use regex to replace
body: <p>I have around 1 thousand lines like the following that I need to amend:</p>
  
  <pre><code>RENAME TABLE my_tablename1 TO ;
  </code></pre>
  
  <p>I want to remove the my_ prefix and then insert the text after the word TO and its immediate space.</p>
  
  <p>So the above example would become:</p>
  
  <pre><code>RENAME TABLE my_tablename1 TO tablename1;
  </code></pre>
  
  <p>Is this possible with regex?</p>
  
  <p>I am working inside sublime if that makes a difference.</p>