title: MySQL - Select specific tables from database
body: <p>I need to get some specific tables in the database, sample.</p>
  
  <pre><code>SELECT table1, table2 table3 FROM data_base ORDER BY DESC;
  </code></pre>
  
  <p>I have found that I can do to get all tables: SHOW TABLES; But I want to bring me specific tables.</p>
  
  <p>¿They know any way?</p>
  
  <p><strong>I found this way also:</strong></p>
  
  <pre><code>SELECT TABLE_NAME AS tb_name 
  FROM INFORMATION_SCHEMA.TABLES 
  WHERE TABLE_NAME = 'city' AND TABLE_NAME = 'city'
  AND TABLE_SCHEMA='test_offers';
  </code></pre>
  
  <p>But it shows one specific table if another conditional, then shows me many repeated tables.</p>
  
  <p>Much appreciate your support!</p>