title: How to move data between table by random position?
body: <p>How to move data between table by random position ?</p>
  
  <p>I use this code for move all data from <code>table xxx</code> to <code>table yyy</code> <code>order by id asc</code>, It's work good.</p>
  
  <pre><code>&lt;?PHP
  include("connect.php");
  $sql = "INSERT INTO yyy
          (name , last_name , tel_no) 
  SELECT 
           name , last_name , tel_no
  FROM xxx order by id asc";
  $dbQuery = mysql_query($sql);
  ?&gt;
  </code></pre>
  
  <p>But now i want to move all data from <code>table xxx</code> to <code>table yyy</code> by random position (not <code>order by id asc</code>), What is the best way to do that ?</p>