title: Rename multiple MySQL tables by inserting an underscore
body: <p>How to rename a set of MySQL tables by inserting an underscore after a keyword. The following example shows what I mean:</p>
  
  <p>current names:</p>
  
  <blockquote>
    <p>keywordcache <br>
    keywordfield <br>
    keywordmenu <br>
    etc.</p>
  </blockquote>
  
  <p>expected names:</p>
  
  <blockquote>
    <p>keyword_cache <br>
    keyword_field <br>
    keyword_menu <br>
    etc.</p>
  </blockquote>
  
  <p>I use phpMyAdmin to access the data base. Renaming many tables one by one is too time-consuming so I'm looking for some automatic method.</p>