title: How to merge multiple tables with similar names in MySQL
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/725556/how-can-i-merge-two-mysql-tables">How can I merge two MySql tables?</a>  </p>
  </blockquote>
  
  
  
  <p>I want to merge multiple tables that have the same structure and make one large table. The tables have similar names, so I want to use the LIKE statement.  Can anyone tell me how I can do this?</p>
  
  <p>The tables are very simple, each having an ID column and a few other columns, but there are a large amount of tables, all of which have names like <code>'TX-xxx'</code>, where <code>'TX'</code> means Texas, and <code>'xxx'</code> are the counties in Texas; you know there are more than 200 counties in Texas. (In fact, I have to do this for all the states.) So I want to use the statement <code>"LIKE 'TX-___'"</code>.</p>
  
  <p>Thanks!</p>