title: how to mysql random select table name
body: <p>perhaps i'm missing something here. I am trying to randomly select a table name from a database that only has numbers/numeric ONLY. Here's what I've gotten but when test running the query, mysql is telling me that my query is incorrect. Any kind of help I can get on this is greatly appreciated!</p>
  
  <pre><code>$sql = "SHOW TABLES FROM `master` WHERE TABLES is NUMERIC ORDER BY RAND() LIMIT 1";
  $result = mysql_query($sql);
  </code></pre>