title: How to remove a prefix name from every table name in a mysql database
body: <p>I have a joomla mysql database with a table name prefix of "jos_" on all of my table names. But I would like to remove it from all of my tables. I understand how to rename each table, one at a time, but I have 600 tables. Is there an easy to run a sql query to do this. </p>
  
  <p>If someone has a solution, could you please post the exact sql query I can use?</p>