title: How to echo random row from database?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/4586858/mysql-how-to-retrieve-a-random-row-or-multiple-random-rows">MySQL: How to retrieve a random row or multiple random rows?</a><br>
    <a href="https://stackoverflow.com/questions/13351718/pull-5-random-records-from-mysql-database">Pull 5 random records from mysql database</a>  </p>
  </blockquote>
  
  
  
  <p>I have a large list of domains in my database in the table "list" under the column "website".</p>
  
  <p>There are about 140 million rows and I just need to know how to echo a random one.</p>
  
  <p>Basically like this:</p>
  
  <pre><code>&lt;?php include('directory/database.php'); ?&gt;
  
  WHATEVER CODE WORKS FOR GETTING A RANDOM DOMAIN FROM THE DATABASE
  
  &lt;?php
  echo $domain;
  ?&gt;
  </code></pre>
  
  <p>There's just a huge amount of records so I need to know the quickest way to just have one of them randomly selected and displayed on a page.  Thanks!</p>